Master and Child Fields

E

Emma

I have a report with a sub report inside. The problem is the Master field
isn't connecting to the right table which has ID as a field instead it's
bringing up the Main table which has ID # as a field so the subform isn't
openning at all because I'm using the wrong ID. How can I change the table
that the Master field pulls from?
 
W

Wayne-I-M

Hi Emma

Op[en the main report in design view
Open the properties box
Make sure that your source is correct - the right table or query.


On the properties box for the sub report
Check the master / child fields are correct
Make sure that this field is shown on "both" the main and sub report - it
can be visible = No, but it must be there
 

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

Similar Threads

Grouping Names in Mail Merge 0
Global layouts 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Report asks for Parameter and Won't Display Subreport 7
Linking One child field or another in subform to main form 4
Forms: linking child/master fields on a non-embedded subform 4
Is this possible? 0
Link Child / Master fields -- QUESTION 7

Top