New to Filemaker
I am new to Filamaker and am stuck creating a report. I have 2 tables, one called BUYERS and the other one called EQT (EQUIPMENT). Both tables are related by a BUYERID which links the buyers table to the equipment table. One buyer could have multiple entries in the equipment table.
The equipment table is a list of equipment owned by each buyer. I have a one-to-many relationship between the BUYER and EQT tables. I want to find buyers that own at least one equipment of a certain brand or type.
I want a field where I can type in a brand or equipment type, and get a list of buyers. In the equipment table I have a brand field as well as an equipment type field.
Thanks for the help!