Access and Lookup Fields

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?

"blaqkikapoo" wrote in
:

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

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?

-----Original Message-----
"blaqkikapoo" wrote
in
:

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

.

See answer in your later thread.

--
HTH
Van T. Dinh
MVP (Access)




"blaqkikapoo" wrote in message
...
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?

"blaqkikapoo" wrote in
:


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