Append Query no duplicates or replace data

[acrowe97]

I have two tables in this tenant database, one that has the contact info of the main contact for each tenant (phone, email, etc.), and one that has the contact info for the rest of the people that work for that tenant (named Tenants and Permissions, respectively). I have a report that uses a query to search for this contact info, but I need it to report info from both Tenants and Permissions so I don't need to have duplicate data. Any suggestions?

[CJ_London]

you should have one table for your contacts and include a field to indicate who is the main tenant e.g.


TenantPK...TenantName...TenantFK
1...…………...Fred...…………...0 (or null) - main tenant
2...…………...Harry...………….1
3...…………….George...……….1
4...…………….Sid...……………..0 (or null) - main tenant
5...…………….Bob...…………….4
6...…………….Nancy...………..1

[acrowe97]

Oh jeez I didn't event think of that... thank you.