Serializing Records By Category
Being new to Filemaker (pro 10), I am having trouble Serializing Records by Category. I have looked at and tried the solutions listed (which all seem to relate to FMP 4 or lower), but can't get them to work. What I want is simple. How to achieve it is proving impossible!
I have a Customer table (containing some 10,000 records) with a CustomerID number field auto generated. I have a Quotes table, linked by CustomerID, which contains multiple finance quotations for each customer. All I want to do is add an auto generated field in this Quotes table, named Quote_No., that sequentially names each quote for each customer, starting from 1. Can someone tell me how to do it please?