In Access I have the following tables: Items, ItemsStyle, ItemsSize, and Sizes.
You can have 1 Item with multiple ItemStyles (Infant, Toddler, Youth, Woman, Man) and each ItemStyle can have multiple ItemSizes (Small, Medium, Large, XL,....). I have this setup so I can see subdatasheets by clicking the + on an item and see the itemstyles and click the + to see the itemsizes. When I click the first record I see
*(dropdown list I want to filter based on the the style I clicked 'infant')
+Toddler (if I click + to expand toddler I only want to see sizes for toddler in the dropdown lookup and not see infant or youth sizes)
Can I do this?