Auto add to Combo box

W

WLMPilot

I have a table contain vehicle info with the Primary Key being the year of
the vehicle and model, ie 05EXPE for 2005 Expedition. I also have a table
for service done on vehicles with its own primary key but also the primary
key from the vehicle table in order to relate the two tables.

My question is this. As a vehicle is entered in the Vehicle table, is there
a way to add that vehicle (say its primary key) to a combo box within the
Service table so that the user can choose which vehicle the service is for
versus having to type the ID in?

Thanks,
Les
 
J

Jeff Boyce

Les

?!You have a "combo box within [a] ... table"?! Check the tablesdbdesign
newsgroup ... the consensus is that lookup data types cause more problems
than they solve. You've described one of them!

The primary problem with the lookup data type is that the table displays one
thing, but actually is storing something else.

Besides, Access tables store data, Access forms display it. You have much
more control and the event actions if you use forms. And you can put a
combo box control on a form and "look up" what you need to...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh original form 1
Append Crosstab Query to Existing Table 0
normalization 2
Reports 2
How to set this up? 9
Details on a Report 1
Should this be two tables? 2
Database design/ tables design 1

Top