Access and Lookup Fields

[blaqkikapoo]

I have created a lookup colomn in a table that gets it's
list from a query that has two colomns. Once I have chosen
from the lookup list, only data from one of the colomns
are visible, but my users need to see both colomns from
the lookup list. How do I do this?

 

[Tim Ferguson]

Once I have chosen
from the lookup list, only data from one of the colomns
are visible, but my users need to see both colomns from
the lookup list. How do I do this?

Look up help for the ColumnWidths property. It should look something like
this:

0;;1.2"

The 1.2" means a width of 1.2 inches, the empty (second) column means use
up all the rest of the available width, the zero means hide the column.

Hope that helps


Tim F

 

[blaqkikapoo]

I do see my two columns in the drop down list. But once I
select an item in the list and tab off the field only the
left column shows. These two columns togethar create a
unique ID.
Table one:
has a unique ID (2004-01)

Table two: uses the unique ID from table one plus a
numbered field
(2004-01) (1) as 2004-01 will have more than one entry in
this table also these two fields create a unique ID and
make up the query used for the lookup list in table three.

Third table: feeds from the 2nd table and needs the
combination of the IDs from the query to make up another
unique ID which is why I wanted both columns to show and
should look like this:
(2004-01) (1) (a)

What would you suggest should be done here?

 

[Van T. Dinh]

See answer in your later thread.

 

[Tim Ferguson]

What would you suggest should be done here?

I missed the mention in your original post of "look up columns". What I
would suggest here is to scrap the look up columns and design the tables
and relationships properly. It does not take much longer and you do end up
with a functioning database. I see that Van has taken things up further
down, so I shan't interrupt any more!

B Wishes


Tim F