Data Type?

[Tansar]

Hi,
Trying to get back into Access after a long time, just need some refreshing tips.

I have 2 tables, one of the tables stores titles (mr, mrs, etc). I tried using the 'lookup' data type to link the data from the other table. This however stores the field as a number and causes problems on my form as only a number is shown rather that the text.

What do I need to do to resolve this?

Thank you.

 

[Dennisk]

Hide the column containing the key of the Title by setting its width to 0

 

[Tansar]

Is that in the Title table? or would that be in the Parents table, which are both linked?

 

[neileg]

Setting the lookup at the table level will trip you up later on. They're more trouble than they are worth. Much better to handle the lookup the old fashioned way in the form with a combo.

 

[Tansar]

Much better to handle the lookup the old fashioned way in the form with a combo.

Thank you for the reply. How can I see in table view contents from another table, what's the best way round this?

TIA.

 

[Tansar]

Hello anyone home

I can see the Primary key (autonumber) field, but cannot see the the other content (this is in the table structure).

A drop drown arrow displays both content (ie primary Key & data), but then leaves the primary data number rather than data i'd like to display.

Any clues?

 

[neileg]

The simple answer is that you don't view data in a table. Tables are for storing data. When you view it, you use a form or a report.