Column Lookup List

[JCJ]

Hi, I have a column in a table that I want to create a lookup on. I only want
the lookup to return rows from the table based on a previous column's data
for that same row. For example, when creating the record, column/field 1 is
"Smith". When I perform a lookup in column 2, I would like only "Smith" rows
from the lookup table in this column to return.

Thanks in advance.

 

[Jeff Boyce]

It sounds like you might be trying to do this entirely within a table.
Don't!

Access tables store data. Access forms display data.

Create a form and use "cascading combo boxes" to do what you described
(check Google.com and mvps.org on the quoted term).

Regards

Jeff Boyce
Microsoft Office/Access MVP