AnsweredAssumed Answered

Serializing Records By Category

Question asked by MikeDunne on Mar 29, 2011
Latest reply on Mar 31, 2011 by philmodjunk

Title

Serializing Records By Category

Post

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?

Outcomes