Cascading Comboboxes

[Purdue2479]

cascading comboboxes

I am creating a database that stores client and carrier rate information. I need to create a form that shows the carrier rate information when a specific client is selected. So when I select the client it pulls a specific list of carriers for that client. I would like to be able to use comboboxes to select client and carrier information. I'm not sure how to setup the tables either. Right now I have a client table which has the client name and id, carrier table with name and id, and tables with carrier rates for each client. Any suggestions on how to go about this would be greatly appreciated. Thanks.

 

[Hayley Baxter]

The sample in this thread might give you a start and a better idea of how to set up your tables. Also if you look at the properties of the combo boxes on the form, you will see how they are being synchronised.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=58586

Post back if you need further hwlp.
Hay