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

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?

I have tried a summary report on both my Table A and on my Link Table. 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). I have double-checked this by creating a test record with no links.

Table A has people's NamesTable B has Activities people are involved Link Table links multiple people to multiple activities

Table A is One-to-many to Link TableTable B is One-to-many to Link Table

I have created a test person that I haven't linked to any activities. This record is ﻿only﻿ in Table A, with no link in the Link Table. 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).

Welcome to QuickBase. It is a wonderfully flexible product. I'm down at their Annual Convention now in Boston along with 800 other Quick Base crazed people.

It sounds like you have set it up the relationships correctly. On the relationship between Names and the Link table, edit that relationship to create the Summary field. It should count the number of link records for each respective Name.