count ID of repeating field???
I am very new to file maker and currently using file maker pro 9 advanced.
I have a repeating field called 'Types of food' which has 3 repetition.
I need to summarize the types of food for example:
Types of food Product1 Product2 Product3
Record 1 milk egg bread
Record 2 cocoa coffee egg
Record 3 cocoa milk milk
into something like this:
I've tried using subsummary but what I get is:
I also tried using GetRepetition() function, but what I get is summary for repetition1 in a report, summary for repetition 2 in another report and summary for repetition 3 in another report.
Can anybody help me?