How to have table automatically update if field = yes

[rnc110]

This is going to be hard to explain so please bear with me.

I have a training database that keeps track of certain required training for each individual job type. Each job has certain reqired training classes that need to be completed. The company however has about 40 manadatory classes that apply to all job types.
I have a table (tblAvailClasses) that has a list of all the availible classes that are offered. There is a yes/no field to specify if it is mandatory or not.

As of right now I have a table (tblRequired) that has simply the fields Position_Num(meaning job position in company) and Course_Num (course that they need to take). I have this table populated to the specifications of each job except for the mandatory classes. Is there someway I can right a query that checks to see if the course is mandatory
if so it throws it into the (tblrequired),if not already in there, for all the job positions that are in the table(tblposition , which contains fields position_num and position_title)

thankyou

ryan

 

[Frink]

Hallo,

You can write an Append Query to add records to the required table.
Write a query to select the records to append, then change it's type to Append, select the table to append to and fill in the field names

- Frink