I am new to file maker,i have a problem
my database has 3 tabels with the following fields
Customers:CustomerID,Address,City
Location:LocatioId,Address,City,CustomerId(fk)
Equipmnet:equipmentID,Type, Serial#, Loactioid(fk)
Each customer mustt have one or more loctions
Each location can have A single peice of equipment
I want my reports or layouts to show
each customer followed by the customers locations
Any help would be very much appreciated thanks