Display data from another table on a subform

[Guest]

Hi,

It's been a really long time since I was in school, and I'm having some
trouble with the database I'm working on.
I have an Orders table and an Order Details table. Both of these are on a
form, with the Order Details being the subform.
I have the user choose the ProductID (Order Details), and then I would like
Access to automatically show the associated ProductDescription (which is
listed in the Products table).

Please help if you can... I'm not sure how to set this up.

 

[Douglas J Steele]

Create a query that joins your Order Details table to your Products table,
joining them on ProductID.

 

[Guest]

Hi Doug,

Thanks for the advice. I've joined the tables, and put in a textbox on the
subform to display the description, but it shows "#Name?".
What should I be putting into the Control Source for this textbox?

--
Thanks again,
Carolyn

Create a query that joins your Order Details table to your Products table,
joining them on ProductID.

 

[Douglas J Steele]

What exactly did you do? Did you create a query that joins the two tables,
and that query is now the recordset for your form? If so, when you run the
query by itself, do you get the correct value?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi Doug,

Thanks for the advice. I've joined the tables, and put in a textbox on the
subform to display the description, but it shows "#Name?".
What should I be putting into the Control Source for this textbox?

 

[Guest]

I joined the two tables, and when I run the query by itself it does display
the description associated with the ProductID. Do I need to create a new
field in my OrderDetails table?

 

[Douglas J Steele]

Are you using the query that joins the two tables as the recordsource for
your form, or are you still only using the Order Details table?

 

[Guest]

As far as I know I'm still using the Order Details table for my form.

 

[Douglas J Steele]

Change it to use the joined query.

 

[Guest]

Thanks Doug!
It's working perfectly now! I really appreciate all your help.