Hello No Coders, I need help with creating multiple relationships. I’m going crazy. My brain is burning and I think it’s easier than I think, but I can’t get it right.
The problem lies in assembling the data sheet with the relationships of categories and sub categories.
I have 4 categories on one sheet:
And I have on another sheet, 2 sub-categories and a product column that depend (children) on each sub-category:
The question is:
How do I build relationships?
Are they well distributed over two sheets or do I need to add more sheets?
I did the flow from left to right, and I need to develop it as follows:
Click on [Category], and [Sub-Category 1] opens showing its content, then when clicking [Sub-Category 1], [Sub-Category 2] opens and shows its content, and by Finally, click on [Sub-Category 2] and show me the final product belonging to that tree.
I would be very grateful if you could guide me to do it myself and learn. Thank you