Displaying data from a different table on a form

G

Guest

I want to display data on my form in textboxes. Some of these textboxes need
to show values from different tables which are linked to the main table the
form is based on.

For example:

I have a JOB table with the field CLIENT_ID which is a foreign key to a
CLIENT table. The CLIENT table has the field CLIENT_NAME. The form is based
on the JOB table. The form shows information from other fields in the JOB
table but I want it to show the CLIENT_NAME and not the CLIENT_ID. The form
is purely for viewing data which is why I want to use the textboxes.

Is the only way to do this by using a Subform ? or can I build an expression
in the textbox properties to show data from a different table ?
 
D

Douglas J Steele

Create a query that joins the various tables together and returns all of the
information you want.

Use that query as the RecordSource for the form, not the table.
 
E

Ed Warren

You can build a query that gives you the values you want. Then build a form
based on that query.
qryDisplay with Information you want to display from the Job table and then
the CLIENT_NAME. Then you can use your text boxes to display the data.

Ed Warren.
 
J

John Spencer

You should probably build the form on a query that joins the Client and Job
table. Optionally, you could use a combobox that has a row source based on
the client table and a CONTROL Source that is the Job.Client_ID.

The Combobox ROW Source should have the Client table ClientID and
CLIENT_NAME in it and should have the width of the Client_ID column set to
zero.
 
G

Guest

Thanks guys, I'm new to Access and figured this would be one of the ways of
doing it, just not a pro at doing queries - yet.
 

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

Top