Troubleshooting Lookup Fields

[blaqkikapoo]

Scenario:

Table 1
UniqueID is created=
2004-01
2004-02
and so on...

Table 2
UniqueID is created from unique ID from Table 1 and
another field using a general number=
2004-01 1
2004-01 2
2004-01 3
and so on...

Table 3
UniqueID is created using Query that holds the unique IDs
from Table 2 and another field using letters=
2004-01 1 a
2004-01 1 b
2004-01 1 c
and so on...

In Table 3, I see the two fields in the lookup drop down
list. But after I have made a selection only the left most
column is visible. I have played around with the column
widths to no avail. So I don't know if this is feasible or
should I be going about it another way.

 

[tina]

i suggest you remove the Lookup fields from your tables. see
http://www.mvps.org/access/lookupfields.htm
for more information.
use forms, with combo boxes to "look up" the linked data, for entering data
into your tables.

hth

 

[Van T. Dinh]

I would advise against the LookUp Fields.

See The Access Web article:

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