How can you create a special type of serial number?
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?