Why can't I find a table in the lookup wizard?

Using Access 2007, I need to create a lookup field for an existing table, but
it is not listed when creating it.

Jenni,

I can't tell by your posting, are you trying to create a circular reference?
Look-up field using the same table you are creating the field in? Well, I'm
going to say it makes sense that it would not be in the list but let me know
if that's what you meant.

On another note... Look-up fields = Bad idea and here's why...

http://www.mvps.org/access/lookupfields.htm

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Jenni" wrote in message
...
Using Access 2007, I need to create a lookup field for an existing table,
but
it is not listed when creating it.

Is the name of the table the first one in the database if you sort them
alphabetically? There's a bug in 2007 where that table won't show up
sometimes. Create a bogus table named A and see if that fixes the problem.

BTW: Lookup tables are evil at table level.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Jenni" wrote:

Using Access 2007, I need to create a lookup field for an existing table, but
it is not listed when creating it.