How do I create blank record with incrementing serial number.
Hi, can anyone tell me how to achieve the following:
After creating a new record and filling in all fields, I want to then create another blank record, but want the field that contains the serial number to increment by one. Please note that I cannot use the auto incrementing serial number function, as the record may be duplicated several times in which case I may have 3 or 4 (or more) records with the same serial number which is what I'm after.
I'm probably looking for a script to do the above, but am new to Filemaker and need to learn more about scripting.
Any suggestions much appreciated.