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.