AnsweredAssumed Answered

Question about relationships and reports

Question asked by bartprins on Aug 5, 2014
Latest reply on Aug 6, 2014 by philmodjunk


Question about relationships and reports


     Hi there,

     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!!