I have an employee training record that has a table containing operations and the required procedures. This is structured as
TrainingRequirementsTable
Operation 1 Procedure 1
Operation 1 Procedure 2
Operation 1 Procedure 3
Operation 1 Procedure 4
Operation 2 Procedure 2
Operation 2 Procedure 5
Operation 2 Procedure 7
Operation 3 Procedure 1
Operation 3 Procedure 3
etc
I have created a dialogue grid that has a pull down menu for employee name and operation and a button
the button opens a grid in a model window that contains the training requirements with 2 fields
Operation Procedure
The number of records depends on how many procedures are needed for that operation as this is just extracted from the TrainingRequirementsTable
In addition, I pass the variable "Employee" from the Dialogue on to the grid and have written code to show the employee name above the grid when it is displayed
Below the grid is a button that appends the data from this grid a large training record table.
I have this part working well
What i need to do is add the employee name to these new records. The name is the same variable that was passed to the grid from the dialogue box and it needs to appear in each record in the Employee field
Since the Employee Name doesn't appear with each record in the grid, I don't know how to append it.
Any help ?
Steve
TrainingRequirementsTable
Operation 1 Procedure 1
Operation 1 Procedure 2
Operation 1 Procedure 3
Operation 1 Procedure 4
Operation 2 Procedure 2
Operation 2 Procedure 5
Operation 2 Procedure 7
Operation 3 Procedure 1
Operation 3 Procedure 3
etc
I have created a dialogue grid that has a pull down menu for employee name and operation and a button
the button opens a grid in a model window that contains the training requirements with 2 fields
Operation Procedure
The number of records depends on how many procedures are needed for that operation as this is just extracted from the TrainingRequirementsTable
In addition, I pass the variable "Employee" from the Dialogue on to the grid and have written code to show the employee name above the grid when it is displayed
Below the grid is a button that appends the data from this grid a large training record table.
I have this part working well
What i need to do is add the employee name to these new records. The name is the same variable that was passed to the grid from the dialogue box and it needs to appear in each record in the Employee field
Since the Employee Name doesn't appear with each record in the grid, I don't know how to append it.
Any help ?
Steve
Comment