Limiting data pulled from another table into a lookup column?

  • Thread starter Thread starter BABs
  • Start date Start date
B

BABs

I have a table with "Site" information and a table with "Equipment"
information that contains a lookup column to pull the Site Name from the
"Site" table. I would like to be able to lock/omit Site Names from the lookup
column that have already been closed, yet keep the info for the closed sites
in the "Site" table.
Is there some way to do this?
Thx
 
BABs said:
I have a table with "Site" information and a table with "Equipment"
information that contains a lookup column to pull the Site Name from the
"Site" table. I would like to be able to lock/omit Site Names from the
lookup
column that have already been closed, yet keep the info for the closed
sites
in the "Site" table.
Is there some way to do this?
Thx
Click to expand...

While it may be possible to use the lookup fields in a table, it is
inadvisable to do so for a multitude of reasons:

http://www.mvps.org/access/lookupfields.htm

Instead, use a query. Add a Yes/No column to your table and use it as a
criteria in your query which will be the recordsource of a form.
 
Lookup columns are taboo. You will find many recommendations i the newsgroup
not to use them. You need to add another field named Closed to TblSite and
make it a Yes/No data type. Then you need to add a combobox to your
Equipment form for entering the site. The combobox needs to use a query
based on TblSite. The query needs to include SiteID, SiteName and Closed.
The criteria for Closed needs to be set to False.

Steve
(e-mail address removed)
 
Back
Top