Main report with multiple sub-reports have common link (ProviderID)

[osimini1]

Please I need a help with issue reated to problem I am having with my report to have subreport to pull or report only data related to common providerId in main report. I have Main report called rptFacility with ProviderID identifying a particular facility. Also, I have 2 subreports in the main. Both subreports are liked to main report (rptFaility) using masterlink (main Report) and childlink (subreport). My problem here is that the report is ran, the main report will report only data associated with the actual and correct facility using ProviderID. Unfortunately, the subreport will pull all other facilites providersID information. What I want is to have subreport pull only the data information (providerid) reported in main report (rptFacility)

Thank you for your suggestion and help in advance

 

[dhookom]

Are you using ProviderID as the linking field? Is ProviderID unique in the record source of the main report?

Duane
Hook'D on Access
MS Access MVP

 

[osimini1]

Yes. Thanks very much I solved the problem because I forgat to link the master and child together.