access_numpty
New member
- Local time
- Today, 05:31
- Joined
- Jan 12, 2009
- Messages
- 7
I have three tables Company, Customers, Order Details
One company can have multiple customer names.
Customers can have multiple orders.
In the order details table I have a lookup field to the customer name/company id to say which company/customer the order is associated with.
I wish to create a form where I can choose a company from the drop down box, and it filters down to the customers associated with that company and populates the order details table to say which company/customer the order is with.
I can use combo boxes from the company table, and customer table to filter down on a choice, then get it to update the lookup field.
However when I go back into the form the combo-boxes stay blank rather than give me the customer name/company name which is in the order details table. How do I get them to show the detail already present?
Hopefully I have explained this in enough English for someone to be able to help me?
One company can have multiple customer names.
Customers can have multiple orders.
In the order details table I have a lookup field to the customer name/company id to say which company/customer the order is associated with.
I wish to create a form where I can choose a company from the drop down box, and it filters down to the customers associated with that company and populates the order details table to say which company/customer the order is with.
I can use combo boxes from the company table, and customer table to filter down on a choice, then get it to update the lookup field.
However when I go back into the form the combo-boxes stay blank rather than give me the customer name/company name which is in the order details table. How do I get them to show the detail already present?
Hopefully I have explained this in enough English for someone to be able to help me?
