Need help with a script for adding a revision number
I need help with a script to add a sequential revision number to a part number. The database is set up with the part number in the main database and the revision database is related. There are 2 fields the part number field and the revision number field. I need to assign a revision number for each part number as revisions are made to the part number. Example: part number 3455 revision 1, pn 3455 rev 2, pn3244 rev 1, pn 3244 rev 2. I am having problems getting this to work.
I am using FileMaker Pro 10.0v3 on a Mac OS X - database stored on FileMaker Server.