Passing the output of a query to a table

[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)

 

[Robert]

It sounds like you are trying to save the same information twice. And you
don't need to do that.

Tables are for saving data. Queries are for looking at data. One table can
be called in more than one / many different queries. The results of these
queries do not need to be saved.

Robert

 

[Mark]

As far as I can tell I am not attempting to save the data twice.

I have a group of linked reference tables that contain competency
information split into: Unit - Cluster - Element - Criteria.

One employee has a quarterly review. Each review contains 3 units, each unit
contains several clusters etc... (see very bottom of page)

I am using the query to pull up a list of criteria based on the Element. I
am aiming to copy this criteria code (1.1.1.1 etc) into a record list linked
to the employees ID. From there I can then attribute a value (eg Good, Bad,
N/A) to each criteria.

I hope that clarifies the situation a little more?

Many thanks

 

[Robert]

Post the layout of all involved tables. Indicate key fields. You can omit
fields which are not involved.

 

[Robert]

Better yet, post all the fields if you can so we can check your table
structure.