I'm working for a school right now, and I've made a "student contacts" database, it holds parent info, school representatives, district contacts, etc. It's related to a "student info" database. In the "contacts" db, I'm developing a sort of "control panel" for printing mailing labels. They want to do things like print the labels for anyone who is a guardian for a specific student. This means (as far as I can think) that I have to perform two finds: First the contacts records that are related to a specific student, and then all of the records within that set that are categorized as "guardians."

I can't figure out how to do this. Anyone have experience with this? I appreciate your input.

There's no need for two searches.

In Find mode, enter the target student value AND the 'guardian' value into a single Find request.

This will result in a found set of all records matching the target student value who are ALSO categorized as 'guardian'.

That's great. Thanks.