Dummy- how to build a fast form

[hortense76]

Hi, I'm new to Access.
I'm trying to do a very simple thing but I can't.
Let's say I sell a lot of cars, every day so I need a database only to collect info about selling. I need a table (SoldCars) which need refers (read: field) to 2 other tables: 1.Constructor and 2.Model, or only to Model (because Construvctor could be redundant). Anyway, when I register a new sold car, I want a menu in which I can find a Model but not after having chosne the Constructor, so when I choose "Ferrari" then I can only find "Testarossa" and "GTO" and choose one of them. Stored field can be Model, because Constructor is implicit. But I need this tip because let's say I sell thousands of cars per day and I want it to be very quick. Please help or I'll die under piles of cars!
Thanks!!!!

 

[ghudson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

You should adjust the SQL [row source] of your combo box to only show data found from the record source. Search the forum for cascading combo boxes to see some examples. dynamic comboboxes

 

[hortense76]

Thanx!!!!!
It works!!!!!!!!!!
I was sure it was that simple....
bye