Pulling records NOT in linked table

[Ken_(Guest)]

Wondering if this is possible. I want to pull a list of people that are in one linking table but do not appear in another linked table. So let^s say I want all children of someone. I link in the table with the children^s names. But then I want non-red-headed children. But I only have another table that lists the red-headed children. I want to link into that table and and use it to list the non-read-headed, so kind of a ^not in^ relation. I can^t figure out how to do that. Is it possible?

[kfleming]

I think it is possible.____If you build a relation from the child name table to the redhead table with a blank failure action you can add a query to include all records where the redhead->name is equal to blank.__This will give you the list of the non-redhead children.____Kathleen__R&R Support