Forum Discussion

KateTheriault's avatar
KateTheriault
Qrew Cadet
7 years ago

Is there a way to create a recursive query in QuickBase to return all items from a table with relationships that may be several layers deep?

I know there isn't a way to to do recursion natively in Quickbase.  I have a bunch of recipes that nest 5 levels deep. I want to create a query to flatten the structure. Is there a dirty way to do ...
APIs and custom code
Ask about Quickbase functionality
Data import and export
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
I have attached an image of the proposed relationship diagram.  I'm not sure how readable it will be when it uploads.  Contact me via the info in my website QuickBaseCoach.com and I will transfer a copy of the app to you.

The Report for a Recipe would be a summary report of the Ingredient Quantity Tables with 4 extra levels of grouping which would be by the 4  levels of Recipe Assignment Tables.

I'm pretty sure that this approach will work.