I have 3 tables that my user needs to be able to work with. It's a pretty standard setup: Customers, Orders, LineItems. I need the user to be able to go into the customer table, add a record, select orders & create the order information, then select Line Items and enter the individual detail information of the items on the order. I can get the customers linked to the order so the two show on the screen but I can't seem to get it to show the 3 levels at the same time. When I select to view the line items when I'm viewing the order then the screen changes to show just the order table as the master level and the line items as the deatil. I want the user to still be able to see the customer level information at this point. Is this possible?
Thank for your help.
Corinne
