AnsweredAssumed Answered

How can you create a special type of serial number?

Question asked by AAgraphics on May 17, 2010
Latest reply on May 17, 2010 by aammondd

Title

How can you create a special type of serial number?

Post

Using FMP10 on Mac and PC

 

I have a table where there is an item number.  I want a separate field to take the item number and add the suffix of "-01".  Anytime the same item number appears, I want this separate field to add the I mentioned in the previous sentence, but not repeat the number.  For example, if I had an item number of "TEST", this separate field would generate "TEST-01" and a second record that had "TEST" as the item number would then have "TEST-02" in this separate field.  This needs to auto generate based on the item number field.  Any ideas of how this is possible?

Outcomes