Lookup column on the same table

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

I would like to create table A and one of these rows is meant to be a lookup
column on the same table.

With Access 2007, this does not seem to be possible through the Lookup wizard.

Any ideas?
 
I would like to create table A and one of these rows is meant to be a lookup
column on the same table.
Click to expand...

Why?

Read http://www.mvps.org/access/lookupfields.htm for a critique of the
unnecessary, obnoxious, and misdesigned Lookup Field feature.
With Access 2007, this does not seem to be possible through the Lookup wizard.
Click to expand...

Use a Form. You can put a combo box on a form referencing the same table as
the form's recordsource, if you in fact have a self-related table. Perhaps you
could explain the nature of the table and what it is that you want to "look
up".
 
Back
Top