Lookup Field

[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?

 

[John W. Vinson]

When using a lookup field,

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.

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?

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]