I have a table of employee names
I have a table of function names
I have a table that shows which operation procedures are associated with each function
I have a table of training records
What I want to do is allow a manager to select a name from the employee list, associate it with a function, generating a list of operation procedures that the employee needs to be trained on to be certified for that function. I need to then append this list to the existing training table.
Employee Table contains the employee name and I will use a dropdown control to allow the selection of a name
Function Table contains rows showing the function name and the associated procedures as rows of data
ie.
function 1 procedure 1
function 1 procedure 2
function 1 procedure 3
function 2 procedure 1
function 2 procedure 4
function 3 procedure 2
function 3 procedure 3
function 3 procedure 5
etc.
the selection of the function will also be from a dropdown list
what I want to is build a table where, for instance, name1 and function1 are chosen and the info returned looks like
name1 function 1 Procedure 1
name1 function 1 procedure 2
name1 function 1 procedure 3
and then append this data to a larger table assigning the results to the relevant fields thus building a training schedule for that employee for the function selected
I am having problems getting started with the basic building blocks I need
I think I need a dialog that generates a new table from the selections made and then a button that appends it. But I am a bit lost as to how to begin.
Any help would be appreciated.
Steve
I have a table of function names
I have a table that shows which operation procedures are associated with each function
I have a table of training records
What I want to do is allow a manager to select a name from the employee list, associate it with a function, generating a list of operation procedures that the employee needs to be trained on to be certified for that function. I need to then append this list to the existing training table.
Employee Table contains the employee name and I will use a dropdown control to allow the selection of a name
Function Table contains rows showing the function name and the associated procedures as rows of data
ie.
function 1 procedure 1
function 1 procedure 2
function 1 procedure 3
function 2 procedure 1
function 2 procedure 4
function 3 procedure 2
function 3 procedure 3
function 3 procedure 5
etc.
the selection of the function will also be from a dropdown list
what I want to is build a table where, for instance, name1 and function1 are chosen and the info returned looks like
name1 function 1 Procedure 1
name1 function 1 procedure 2
name1 function 1 procedure 3
and then append this data to a larger table assigning the results to the relevant fields thus building a training schedule for that employee for the function selected
I am having problems getting started with the basic building blocks I need
I think I need a dialog that generates a new table from the selections made and then a button that appends it. But I am a bit lost as to how to begin.
Any help would be appreciated.
Steve
Comment