A
azu_daioh
Hi All,
I have this query:
SELECT "ID Referral" as TableName, logID, actID, caseNum FROM
[tbl_logReferralAction] WHERE [caseNum] = Forms!frm_AdvSearch!
findKeyword
UNION ALL SELECT "Doc Request" as TableName, logID, refNum, caseNum
FROM [tbl_LogDocRequest] WHERE [caseNum] = Forms!frm_AdvSearch!
findKeyword;
But, how do I display additional fields from another tables:
From [tbl_Claimant] (pk: clmtID) I want to add these fields
[clmtFName] and [clmtLName]
From [tbl_LogBasic] (pk: logID), I want to add these fields [logSSN]
From [tbl_Claim] (pk: clmID), I want to add these fields [ofcNum] and
[effDate]
The [tbl_LogBasic] has fk: clmID and clmtID.
Any help is greatly appreciated.
Thank you,
I have this query:
SELECT "ID Referral" as TableName, logID, actID, caseNum FROM
[tbl_logReferralAction] WHERE [caseNum] = Forms!frm_AdvSearch!
findKeyword
UNION ALL SELECT "Doc Request" as TableName, logID, refNum, caseNum
FROM [tbl_LogDocRequest] WHERE [caseNum] = Forms!frm_AdvSearch!
findKeyword;
But, how do I display additional fields from another tables:
From [tbl_Claimant] (pk: clmtID) I want to add these fields
[clmtFName] and [clmtLName]
From [tbl_LogBasic] (pk: logID), I want to add these fields [logSSN]
From [tbl_Claim] (pk: clmID), I want to add these fields [ofcNum] and
[effDate]
The [tbl_LogBasic] has fk: clmID and clmtID.
Any help is greatly appreciated.
Thank you,