Batch Entry Using Script and Global Fields
Mac OS X 10.5
FMP 10 Advanced (Beginning User)
They are joined by a unique personal ID #.
Layout 1 lists all the employees as listed in the Personnel table.
Layout 2 records all individual leave and comp time accrued and used.
Layout 3 is where I would like to batch enter vacation time accrued or used and it shows information from the Personnel table.
In the header of Layout 3, I have global fields that contain the data I would like to batch enter:
and in the body, I have the list of employees names with a checkbox labeled “No”.
I would like to push one button that will record all global data (for employees where the “No” checkbox is unchecked) into Layout 2 where the field names are the similar to the global fields (sans "g_" prefix):
Currently I have a button beside each of the names where the user must click it to add the record, however I’m trying to make it easier by the use of only one button.
I’ve searched the forums, however I don’t know the correct keywords to get the correct answer.
Any help would be appreciated.