If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Why can't I find a table in the lookup wizard?
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. |
#3
|
|||
|
|||
Why can't I find a table in the lookup wizard?
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. |
Thread Tools | |
Display Modes | |
|
|