Question about relationships and reports
Probably a noob question, but i'm justing getting started with FM again and don't seem to get it
I've got 2 tables where there is a relation between the 2 one table is called CustomersTbl the other ProductionTbl they have a relation between the fields ClientId and ProductionId where ProductionId has the options turned on the create records and delete records.
One client can have multiple productions, now i want to create a field for a report which sums up the amount of customers which have production records.So the customers that don't have any production don't have to be counted.
Much oblidged for your help!!