How to display the data from a linked table

  • Thread starter Thread starter keers
  • Start date Start date
K

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
 
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.
 
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 -
Click to expand...

Hi Christopher

Thanks for the solution - works a treat.

Kiers
 
Back
Top