Lookup column on the same table

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

 

[John W. Vinson]

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

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.

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".