Text box Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text box on my report and the Control Source for it is a Foreign Key
field BodyPartID in my tbl_MainForm table. In my report based on
tbl_MainForm instead of showing the BodyPartID I want to see the Body Part
Description. The problem is the description is in a different table. Is
there anyway I can see the description instead of the Id even though just the
BodyPartID is stored in the table?

Thanks in Advance.
 
Playa,
Hopefully, there is a "realtionship" between the ID table and the
Decription table. You didn't indicate the Desvription table, so I'll use
tblDescription.
If the Description field in tblDescription has a BodyPartID associated
with it, then you can "link" the two tables (by the BodyPartID) in the query
behind your report.
Then the BodyPartID will have an associated Description to place on the
report.

Don't mean to chide... but BodyPartID in one table and Description in
another is not good design. If there's any possibility, I'd try to
re-combine them into tbl_MainForm. Just a suggestion...
hth
Al Camp
 
Playa said:
I have a text box on my report and the Control Source for it is a Foreign Key
field BodyPartID in my tbl_MainForm table. In my report based on
tbl_MainForm instead of showing the BodyPartID I want to see the Body Part
Description. The problem is the description is in a different table. Is
there anyway I can see the description instead of the Id even though just the
BodyPartID is stored in the table?
Click to expand...


You can base the report on a query that Joins the table with
the descriptions table. Then you can add the ddescription
to the field list and us it in the report instead of the
foreign key value.

Another way (in most cases much slower) is to use a text box
with the DLookup function.
 
Back
Top