Good ole ISO 9000 document control procedures--been there done that...
I suggest that you set up a special relationship to a different occurrence of the training records table just for this purpose with "allow creation of records via this relationship" enabled.
The relationship would be defined as:
Employees::EmployeeID = EmployeeTrainingRecords|add::EmployeeID AND
Employees::gSelectedVersionNumber = EmployeeTrainingRecords|add::VersionNumber
gSelectedVersionNumber would be a field with global storage specified so that you can specify this value once for all records in your Employees table.
Then you can perform a find for all active employees and use a looping script such as this:
Enter Find Mode 
Set Field [Employee::Status ; "active"]
Set Error Capture [on]
Perform Find 
IF [ Get ( FoundCount ) ]
Set Field [ EmployeeTrainingRecords|add::VersionNumber ; Employees::gSelectedVersionNumber ]
Go To Record/Request/Page [ Next ; exit after last ]
The set field step will create a new record if one does not exist. If one exists, it assigns a value to the existing record that is already present in that field and thus no change to your data takes place.
Phil, Thank you for your helpful response. As always, your vast knowledge is so appreciated. Thank you for sharing.