Lookup column assignment

[Nswett]

Fairly new to Access and am having trouble figuring out what is probably a
simple question...

I have a databse I use to store various vehicle information...make, model,
vin, plate #, etc. I've also created a table listing the parking passes. In
the main database I've created a lookup column that lists the parking
passes. Of course the lookup column allows me to choose each pass regardless
if its already been assigned...any way to have that drop down list only allow
you to assign passes not already assigned?

Thanks!

 

[Jeff Boyce]

In your description, you bounce back and forth between "database" and
"table". In Access, tables store data. The entire Access .mdb file is
known as a database (which can include queries and forms and ...).

It sounds like you may be working directly in the tables (rather than, the
preferred method, via forms). It also sounds like your table definition
includes a "lookup" data type field. If so, this can get very confusing, as
it stores one value (the lookup table's primary key value) but displays
something else (the looked-up value).

If you want to control which items show up on a combobox, use a form, and
limit the list returned in the query behind the combobox.

Regards

Jeff Boyce
Microsoft Office/Access MVP