Serial Number Reset Script

[ashill]

This is beyond my basic scripting skills.

I want a field with a serial number in it to reset each time a different field is changed from the previous record.

More specifically, I have a field that contains a drawing number. I have a button that inserts the data from the previous record into this field. The drawing number might be the same for 80 records or just 2. Each time it is changed to a new drawing number I want the serial number field to reset to 1.

Any ideas?

Thanks!

[ashill]

I'm still stuck on this. I guess my problem is that I don't know how to script the first part.

"If Field A has changed from the previous entry",

Set next serial value [DB::Field2;1]

Is there a good glossary of "script language" anywhere?

Thanks

[Vaughan]

Yes... FileMaker Help.

Or search the FileMaker Knowledge base for the script reference. It's a pdf with all script steps listed and explained. There is a similar document for functions too.

I printed them both and had them comb bound back-to-back, that's my working reference while developing.