Updating drop down list after entering data

[robertfp]

Hi all



My database will consist of three tables, "Customers", "Equipment" and "ServiceRecords". Each piece of equipment can only be owned by one customer, but each customer can own several pieces of equipment. When registering new equipment I will pick which customer it belongs to in the form (there are no duplicates of equipment and it will forever and ever be owned by the same customer), I do this now using the lookup-wizard.

When I'm entering data into my "ServiceRecord" I want to first pick a customer, then pick equipment from a list containing only the equipment that this customer owns. That means that the Equipment list in the ServiceRecord form must be updated when I pick a customer. I can do service on the same equipment many times.

Can someone please tell me how I should structure this, how I should link the tables together and so on? Needless to say, I'm new to Access.

Thanks a lot!

[RuralGuy]

THe query that lists the equipment simply needs to reference your current selection of a Customer.

[joelmeaders]

Make sure each customer, equipment and service record has a unique ID.

The equipment table needs a field to hold the customer ID it is linked to. customer id to equipment id is one-to-many.
The service record table can be linked to the customer ID. Customer to service record is one to many if the customer can have multiple service records.

RuralGuy already listed the final step.