I have (2) tables as shown in (tables.jpg) which have a contact name whose ID number is the same in each table. I have drawn a dotted arrow between each ContactID, which is a FK for [tbl-Contacts].[ContactID].
If I run a separate query using the ContactID # 8311 on one table at a time, my result is (40) calls for qry_AIAs-ContactNotes1 and (44) records in qry_JPNotes.
The issue arises when I want to find the calls notes in each table for ContactID. qry-Test-Calls-AIA is the underlying query and it results in (1760) records.
Hopefully there is an easy answer to this issue.
Thank
If I run a separate query using the ContactID # 8311 on one table at a time, my result is (40) calls for qry_AIAs-ContactNotes1 and (44) records in qry_JPNotes.
The issue arises when I want to find the calls notes in each table for ContactID. qry-Test-Calls-AIA is the underlying query and it results in (1760) records.
Hopefully there is an easy answer to this issue.
Thank