How might one emulate an outer-join in a View? Example, I want my base to store recipe info in 3 tables; Recipes, Steps, Step Details. One Recipe has many Steps. One Step may have many Step Details.
The Recipes table has fields like Recipe Name, Description, Prep Time.The Steps table has fields like Procedure. The Step Detail table has fields like Ingredient, Quantity, Measure.
Since the Page Designer block must be based on only 1 table, I tried creating a view based on Step Details to lookup fields from Recipes and Steps. Problem: if there is a Step with no associated Step Detail (ie. no ingredients), then that Step does not show up in the view!
It seems that if your table structure is more than 2 tables deep, you cannot pull all needed fields together in one view. I am currently evaluating Airtable as a platform for much larger projects. If the above is correct, that is a deal-killer. Suggestions anyone?
Tig