October 8, 200718 yr Newbies 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
Create an account or sign in to comment