Different Sequential Numbers in same Database
I am setting up a database for my distributors in Filemaker 9 which allows them to create their own quotes. However the problem is I want them to have their own sequential numbers so they cannot see how many other quotations or orders are being placed by other distributors
So if I have three distributors called Jack, Jill and Pail I want Jack to create a quote and it to be JackQuote1, he then creates another quote and it is called JackQuote2 - which is easy to do as the database allows for this as standard. However when Jill creates a quote, on the same database, I want this to have the numbers JillQuote1, 2 and so on.
Is there a way I can do this?