AnsweredAssumed Answered

New to Filemaker

Question asked by MauricioJurin on Jan 25, 2011
Latest reply on Jan 25, 2011 by philmodjunk


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!