Lookup Field

  • Thread starter Thread starter Rose
  • Start date Start date
R

Rose

When using a lookup field, which gathers its data from another table, is
there a way to create criteria breakdown without doing a query.
For example. I have a large rolodex table with hundreds of addresses
(tblRoladex). In one field, I have Address Type i.e. Home, Business. I
want to create a lookup field within another table tblClient that looks up
those organization names that are under the Business Category only within
tblRoxadex. Currently when I create a lookup, it pulls all the
organizations within the tblRoladex. Any Ideas?
 
When using a lookup field,
Click to expand...

Don't.

See http://www.mvps.org/access/lookupfields.htm for a critique of this
misfeature.
which gathers its data from another table, is
there a way to create criteria breakdown without doing a query.
Click to expand...

Why on Earth would you not want to use a query? Queries are ABSOLUTELY
FUNDAMENTAL to any productive use of Access. That's like saying "I want to use
Excel spreadsheets but not use any expressions in cells".
For example. I have a large rolodex table with hundreds of addresses
(tblRoladex). In one field, I have Address Type i.e. Home, Business. I
want to create a lookup field within another table tblClient that looks up
those organization names that are under the Business Category only within
tblRoxadex. Currently when I create a lookup, it pulls all the
organizations within the tblRoladex. Any Ideas?
Click to expand...

Use a Form rather than using the table datasheet; you can put a combo box on
that form for the Address Type, and a second combo box based on a Query of the
Roladex table, using the first combo box as a criterion in order to show only
the selected type of addresses. You can easily do this on a Form; you cannot
do it with a table lookup (only one of many limitations to the lookup field).

John W. Vinson [MVP]
 
Back
Top