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
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.