How to display the data from a linked table

[keers]

Hi All,

I have to tables; 1 contains reference data (2 fields, ID, Product
name), the second table contains Orders (numerous fields including
product name). when I look at the orders table directly, it happily
displays the product (as text). however, when i display the order via
a form all i get is the product ID. How do i get the form to display
the text equivalent?

TIA

Kiers

 

[Christopher Robin]

Your form is based on the Orders table only, and will not automatically
display data from another table. You'll have to edit the query for the form
and add the other table, so that you can select controls from that table to
display.

 

[keers]

Your form is based on the Orders table only, and will not automatically
display data from another table.  You'll have to edit the query for the form
and add the other table, so that you can select controls from that table to
display.






- Show quoted text -

Hi Christopher

Thanks for the solution - works a treat.

Kiers