Hi!
I have the following situation:
Table 1: Products
Table 2: Recipes
Table 3: connects products and recipes in a many to many relation
In a products table view, I need to display a text collumn with all the recipes each product is related, delimited by ","
I guess this involves using the Related Table3 virtual collumn, that has the REF_ROWS formula, but I'm not sure.
If I were building this, Table3 would have one Ref column [Product], and a second Ref column [Recipe]. This would auto-create the [Related...] VC in Product table. Then you can get all Recipes for a Product with [Related...][Recipe]
https://help.appsheet.com/en/articles/4575708-list-dereference
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |