Peopletbl is the 'one' table and breedtbl is the 'many' table. I have a form peoplefrm with a Breed subform on it for the many breeds. I want to search for People records (and open the people form) with a particular breed as the criteria.
The only way I have been able to make this work is if I base the form on a query with both tables in it. Of course, what I get is multiple records for the same person in my search. I want only one record for each person to show.
Is there any way to search for records using the data in a subform as criteria, and show only one record for each record in the 'one' table?
The only way I have been able to make this work is if I base the form on a query with both tables in it. Of course, what I get is multiple records for the same person in my search. I want only one record for each person to show.
Is there any way to search for records using the data in a subform as criteria, and show only one record for each record in the 'one' table?
