Displaying Information in one Table based on information in anothe


Ray C

I have a Table containing Suppliers Information and the two fields I am
interested in are "SupplierID" and "SupplierName",
I have a Customer Table that contains the "SupplierID".
I have a Form that is based on the Customer Table.
On that form, I can easily pick and display the "SupplierID" because that
info is held in that particular Table.
What I want to do is to display the "SupplierID" from the info held in the
Customer Table but I want to use that ID Number to look up the "SupplierID"
held in the Supplier Table and display "SupplierName" info associated with
that "SupplierID".
I can do this in a Combo Box by setting the "RowSource" but I dont know how
to do it with a Text Box.
Can anyone help Please?
Thanks RayC

Arvin Meyer [MVP]

As you mentioned, a combo box would be easier, but if you really want to use
a textbox:

Instead of basing your form directly on a table, base it on a query where
the 2 tables are joined on SupplierID. Add the name from the Supplier's
table and display it in the text box.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question