Hi All
For sake of my sanity. Can anyone please explain/teach me once and for all how can I display data that are relevant to one record but have related data scatered in related tables all over the place?
Scenario:
Order (parent table)
Order line item (related table)
Product(related to above)
Product Characteristic(related to above)
Characteristic(related to above)
Characteristic Option (related to above)
Example:
I want to display repeater component of all product characteristics related to one product as inputs an their characteristic options as dropdown choices.
Im creating 2 data resources to look up records: 1. Product characteristic table
2. Characteristic Options
How do I connect them to see which product characteristic has what options?
Than You!
