I am recreating a report originally built in MS Access using CRXI. I have 2 tables and one querry. I'm not as familar with Crystal Reports as I'd like to be. Can someone help me interpret how to properly translate the link options from Access to Crystal Reports?
One of the links is
Left Table Name: tbl_Client Right Table Name: tbl_ClInsured
Left Column Name: ClientNum Right Column Name: ClientNum
I want to Only include rows where the joined fields from both tables are equal.
The second link is
Left Table Name: tbl_ClInsured Right Table Name: qry_Insured_Spouse
Left Column Name: ClientInsuredID Right Column Name: ClientInsuredID
I want to Include ALL records from 'tbl_ClInsured' and only those records from 'qry_Insured_Spouse' where the joined fields are equal.
One of the links is
Left Table Name: tbl_Client Right Table Name: tbl_ClInsured
Left Column Name: ClientNum Right Column Name: ClientNum
I want to Only include rows where the joined fields from both tables are equal.
The second link is
Left Table Name: tbl_ClInsured Right Table Name: qry_Insured_Spouse
Left Column Name: ClientInsuredID Right Column Name: ClientInsuredID
I want to Include ALL records from 'tbl_ClInsured' and only those records from 'qry_Insured_Spouse' where the joined fields are equal.