AnsweredAssumed Answered

Different Sequential Numbers in same Database

Question asked by Nitram on Dec 22, 2009
Latest reply on Dec 23, 2009 by comment_1


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?