Tables For Car Showroom Database

[connordrew]

I am constructing a database for a local car sales company and I would like to have the tables set so that if the user selects Vauxhall from a drop down menu, then all the Vauhall Models would appear in the model column. Equally, if they choose ford from the manufacturers column, then all the different ford model cars would be displayed in the model

Any ideas?

 

[Parker]

I am constructing a database for a local car sales company and I would like to have the tables set so that if the user selects Vauxhall from a drop down menu, then all the Vauhall Models would appear in the model column. Equally, if they choose ford from the manufacturers column, then all the different ford model cars would be displayed in the model

Any ideas?

Search for cascading combo boxes