Linking subreport to main report problem

[Jennifer]

I have a main report and 3 subreports.
The main report and 2 subreports all have a field that is named the same
(OPP_ID) that links them all together.
The 3rd subreport has a field named OPPORTUNITY. I can't rename this field
in the table due to all the changes that would entail throughout the db.
Is there someway to link this field OPPORTUNITY to the other 3 named OPP_ID
within this report?

 

[KARL DEWEY]

They do not need to be named the same but must be the same datatype.

 

[Jennifer]

Thanks for the quick response but I don't think that solves my problem as all
the fields are the same datatype...text.

 

[Duane Hookom]

Karl is simply suggesting to use the names of the fields since they don't
have to be the same name. They do need to have the same data values in order
to link.

If you can't figure it out, you can add a column to the third subreport's
record source like
OPP_ID: OPPORTUNITY
This will create a new column with the OPPORTUNITY value but a different
name. This shouldn't be necessary.