Prev: Totals on a Report
Next: ACCESS 2010
From: Jenni on 24 Mar 2010 17:46
Using Access 2007, I need to create a lookup field for an existing table, but
it is not listed when creating it.
From: Gina Whipp on 24 Mar 2010 18:41
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" <Jenni(a)discussions.microsoft.com> wrote in message
news:0C4CF3C7-51C7-4D38-891A-54DE347C166B(a)microsoft.com...
Using Access 2007, I need to create a lookup field for an existing table,
but
it is not listed when creating it.

From: Jerry Whittle on 25 Mar 2010 10:56
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.
 | 
Pages: 1
Prev: Totals on a Report
Next: ACCESS 2010