Find record from Table A that is not linked to Table B

Question

I suspect this is fairly easy and possibly already has an answer in another thread, but I can't find one.

I have 2 tables (Table A and Table B) linked together through a third table (Link Table). I am trying to find records from Table A that are not linked to Table B. i.e. they don't exist in the Link Table.

How can I create a report that finds the records in Table A that aren't in my Link Table?

Thanks.

quickbasecoachd · Answer

If you create a summary report of the # of link records, then the unlinked records are the ones which have  the [# of Links] = 0

mikemike · Answer

So this would be on my Table A, correct? &nbsp;I'll have a look.

mikemike · Answer

I have tried a summary report on both my Table A and on my Link Table. &nbsp;Table A doesn't give me any link details to count, the Link Table only has the records that exist in the link table (so there are no Links = 0). &nbsp;I have double-checked this by creating a test record with no links.

quickbasecoachd · Answer

Can you tell me the relationships between all your tables?

mikemike · Answer

Three tables:Table A has people's NamesTable B has Activities people are involved&nbsp;Link Table links multiple people to multiple activitiesTable A is One-to-many to Link TableTable B is One-to-many to Link TableI have created a test person that I haven't linked to any activities. &nbsp;This record is&nbsp;_only_ in Table A, with no link in the Link Table. &nbsp;I am trying to produce some kind of report that will tell me that this record is not in the Link table (and any others that might be similar).

Forum Discussion

Find record from Table A that is not linked to Table B

Related Content

How to Link Tables in a Complex Many-to-Many Relationship?

Filter out some records on related table

Using Grid Edit to Edit Multiple Records at Once

View all Parent records and related Child records in single table view

Record Details