Table Lookup

[Guest]

By using the Lookup tab's Row Source I have narrowed my choices in my table's
(tblMain) field. Now when I go to my table and click on the Year field the
following choices appear.

Lookup Query:
Feeder Year
F123 2005
F345 2007
F123 2006

However, I would like this query to be limited even further by the Feeder
field in tblMain. I have tried a wide range of options but cannot seem to
use a field in tblMain to filter this lookup query further. Any thoughts?

 

[Jeff Boyce]

If I understand your description, you are using a Lookup datatype in an
Access table. Visit the tablesdbdesign newsgroup to see the strong and
quite vocal consensus AGAINST using this approach. It isn't so much that it
is wrong (OK, so some folks DO think it is just wrong), as that it displays
one thing but stores something else. This proves to be confusing to most
everyone.

Instead, rather than working directly in the tables (Access tables store
data), use Forms (Access forms display data). You can use "cascading combo
boxes" in a form to string together lookup-type fields, the first choice
used to limit the second, the first two to limit the third, ...

Regards

Jeff Boyce
Microsoft Office/Access MVP