combobox help

[Adam1970]

Hi



I have a form that lists the following

Customer Name (combobox to select the customer)
Customer delivery address (combobox to select from multiple addresses linked to that customer)

at present the customer delivery address combobox shows every delivery address for every customer (I have customerID within the delivery address table which is linked to customer table) how do i limit the combobox to only show addresses linked to the customer?

Thanks
Adam

[mike60smart]

Hi Adam
To save me having to create this can you upload a zipped copy of the database?

[pbaldy]

Sounds like cascading combos:

http://www.baldyweb.com/CascadingCombo.htm