M
Mark
Hello
I am attempting to create an employee competency database and have been on a
steep learning curve.
I am at the point where I have created a query that will filter the
individual performance criteria into a subform.
What I am now attempting to do is to pass some values from one column in the
query output, into a pre-existing table, with each row from the query output
creating a new row in the records table.
I hope that makes sense?
Below is an idea of the structure. The tbl_ReviewContent &
tbl_Element_Criteria_Subform both save to one table (called ReviewContent)
Any help is greatly appreciated.
Mark
tbl_ReviewHeader:
ReviewID (autonumber)
Employee_ID (lookup from tbl_employee)
JobTitle (lookup from tbl_jobs)
ReviewPeriod (lookup from tbl_reviewperiod)
tbl_ReviewContent:
ReviewContentID (autonumber)
ReviewID (linked to tbl_ReviewHeader)
Unit (combo selection)
Cluster (combo selection)
Element (combo selection)
tbl_Element_Criteria_Subform:
Criteria
Rating
Notes
The competencies are linked on a one to many basis e.g.
Unit = 1
Cluster = 1.1 (1.2, 1.3, 2.1 etc)
Element = 1.1.1 (1.2.1, 1.3.1, 2.1.1 etc)
Criteria = 1.1.1.1 (1.2.1.1, 1.3.1.1, 2.1.1.1 etc)
I am attempting to create an employee competency database and have been on a
steep learning curve.
I am at the point where I have created a query that will filter the
individual performance criteria into a subform.
What I am now attempting to do is to pass some values from one column in the
query output, into a pre-existing table, with each row from the query output
creating a new row in the records table.
I hope that makes sense?
Below is an idea of the structure. The tbl_ReviewContent &
tbl_Element_Criteria_Subform both save to one table (called ReviewContent)
Any help is greatly appreciated.
Mark
tbl_ReviewHeader:
ReviewID (autonumber)
Employee_ID (lookup from tbl_employee)
JobTitle (lookup from tbl_jobs)
ReviewPeriod (lookup from tbl_reviewperiod)
tbl_ReviewContent:
ReviewContentID (autonumber)
ReviewID (linked to tbl_ReviewHeader)
Unit (combo selection)
Cluster (combo selection)
Element (combo selection)
tbl_Element_Criteria_Subform:
Criteria
Rating
Notes
The competencies are linked on a one to many basis e.g.
Unit = 1
Cluster = 1.1 (1.2, 1.3, 2.1 etc)
Element = 1.1.1 (1.2.1, 1.3.1, 2.1.1 etc)
Criteria = 1.1.1.1 (1.2.1.1, 1.3.1.1, 2.1.1.1 etc)