Passing the output of a query to a table

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)


.

Loading