Repeating Fields

[New Roy]

I am new to Filemaker. Am using repeating fields in an invoice. How do I analyse all the itmes used in a repeating field?

eg say from 10 records that have 5 items each in a repeating field, I would like to create a report that would group the items by type from all 10 records and have sub totals etc.

is this possible?

thanks

[dkemme]

Look at the extend function in define fields in the online help file. But I would seriously avoid repeating fields, instead create a related table. Repeating fields lead to many problems down the line, although easier to set up initially.

[bruceR]

You can't get there from here. This is a beginner's mistake. You absolutely need to DUMP THE REPEATING FIELDS! Filemaker is a relational database and you need to use a proper normalized data relationship with Invoice and InvoiceItem tables. There are a zillion invoice examples.