Forum Discussion

MikeMike's avatar
MikeMike
Qrew Cadet
9 years ago

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).  ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
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's avatar
MikeMike
Qrew Cadet
9 years ago
Three tables:

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

Table A is One-to-many to Link Table
Table 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).