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 ?
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 ?