Lookup Columns

[punkspoodle]

Hello again!

How do I prevent the information in lookup columns from showing up in other tables, queries, etc... as numbers.

Example.

Lookup to Fruits. Where the records for fruits are Apple, Banana, Orange, and Pear.

The lookup column lists all the items {Apple, Banana, Orange...}, but in queries the data just appears as numbers {1, 2, 3}.

Many thanks for anyone's help in advance!

 

[Len Boorman]

so what fields are in the queries

I suspect 1 means bananas cos the lookup table when constructed had a single field and when cloed after design no primary key had been set.

Access then said No PK set shall I create one and somebody said Yes. bad move. If you have not given consideration to PK's and defined it yourself then you are in deep trouble

So Look at the data structure and get it sorted

L

 

[punkspoodle]

Ok. thanks!

 

[Rich]

Or you've added the wrong column from your lookup table to the query

 

[Pat Hartman]

This is the expected behavior. The key value is stored in the main table, not the text value. When you want to show the text value, you create a query that joins the main table to the lookup table. Then you can select the foreign key value from the main table and the text value from the lookup table so that your form/report can show either or both.

 

[Ahnetworks]

This is the expected behavior. The key value is stored in the main table, not the text value. When you want to show the text value, you create a query that joins the main table to the lookup table. Then you can select the foreign key value from the main table and the text value from the lookup table so that your form/report can show either or both.

How exactly should one go about doing something like this?

Thought I would ask..I have the exact same problem. I am trying to join the CustomerName with the CustomerPK. But it looks like if I do that, I will need to re-establish many of the relationships to look at the join query and not the master table..right?