Subreport error

[Guest]

Hello,

I have three tables tblMainInsurance, tblMainInsDetail, tblMainInsCovered.
Here are the fields.

tblMainInsurance
MainInsuranceID (AutoNumber)
ContactID (Number) --1 to many relationship with my main table in database
tblContacts.
InsActive (Y/N)
InsAgent (SQL - pulls from tblContact)
InsCarrier (SQL - pulls from tblContact)
InsNotes (Text)

tblMainInsDetail
MainDetailID (AutoNumber)
MainInsuranceID (Number) ---one to many relationship tblMainInsurance
DetailActive (Y/N)

tblMainInsCovered
CoveredID (AutoNumber)
MainDetailID (Number) ---one to many relationship tblMainInsDetail
InsType (Text)
InsPolicyNumber (Text)
InsEffectiveDate (Date)
InsTermDate (Date)


I then created a form that opens through my frmContact via command button.
I loaded my data through the form. Works great.

So now I am creating a report "BY Agent"

I created a query for and report for the Agent and Carrier and a embedded
subreport for the detail policy information. So finally here is my problem.
I need to do a subreport in the subreport I already created to list all our
companies that are under the detailed policies. When I do this through the
wizard I get a message on the last step "The link you selected can't be used.
This link was created based on relationships between source tables. To use
this link, you must go back to the previous page and include the missing
fields.

I did this...I went back and made sure all the fields were selected. I
tried a query with all the fields listed. I don't know what else to try.
Does anyone have any ideas? Or can this be done? Have I provided enough
information? Thank you in advance.

 

[Arvin Meyer [MVP]]

I don't know of any way to create a subreport within another subreport since
there isn't any way a choosing which record is selected in the first
subreport. If there is only 1 possible record, build a query that uses the
tables from both the main report and the first subreport to find that
record, then build a subreport with a recordsource that will link to that 1
record.