If my Forms (tables) were:
Product (i.e. Product Type field contains "Beverage," for instance)
Brand (i.e. Product Brand field contains "Wow Cola", which is selected as a "Beverage" from the Parent forms lookup field dropdown.)
Type (i.e. Diet Wow or Cherry Wow, etc, which is selected as a "Wow Cola" from the Parent form's lookup field dropdown)
Can I show all three fields on the "Type" form from the Parent form
AND the Parent form's Parent form?? I want to see on the Type form that it's Diet Wow from Wow Cola and that it's a beverage. It's the beverage that I don't know how to get on there. (And I don't want to make the Type form link directly to the Product form.)
I hope that makes sense. Kinda confusing when I try to write it out!