Report join should display info from Primary & Secondary table
SummaryReport join should display info from Primary & Secondary table
I have contact table with primary employment detail and custom object secondary employment details.
Relationship contact(c_id) -> CO$SecEmp(ContactID)
For example a member contains 2 secondary employment details.
When I make a join report shows 2 records but, I want to show 3 records (1 for primary and 2 for secondary)
ContactID Branch Employer
1 PriBranch1 PriEmployer1
1 SecBranch1 SecEmployer1
1 SecBranch2 SecEmployer2
How to do this in report?