Showing names instead of ID

[lck092580]

I have a table that has a field that queries another table that also queries another table.

Here's a simplified version:

table 1, field 1 -- references --> table 2, field 1 -- references --> table 3, field 1

The problem I'm having is that if I go to table 1 and choose from the combo box, I see the ID value from table 3.

Thanks.

 

[Remou]

If I read you correctly, the look-ups you have used are not recommended:

http://www.mvps.org/access/lookupfields.htm

 

[lck092580]

Thanks for the tip.

I take it I should create forms and format them appropriately instead right?

 

[Remou]

That, and queries, should give you a set-up that has what you need. Comboboxes and listboxes can be used to present names, rather than IDs, in a similar way to look-up fields. For example, the three tables you mention can be related to one another in a query and the fields you need presented in a combobox.