Scenario:
Two tables were created. tblMainMember with the following columns: PolicyNumber; LastName; FirstName; IDNumber; DOB and the second table: tblDependents with the following columns: PolicyNumber; DPLastName; DPFirstName; DPIDNumber; DPDOB. Within tblMainMember - the PolicyNumber is the primary key. In the tblDependents NO primary key. The relationship between the two tables is ONE/MANY - tblMainMember(ONE) and tblDependents(MANY).
Use "Form Wizard" to create a frmMainMember with a subform frmDependents. Create 4 main members with all its detail where 3 of the main members have dependents.
Use "Report Wizard" and create a report with all the detail.
My problem: The one main member with NO dependents does not appear on the report. Why? Is there a way to show it on the report.