Append records to a 'many' table automatically

[MrsNic]

I have built a database that keeps a record of the skills a student has used in a particular piece of coursework. The coursework_skills table has a primary key made up of SkillID and CourseworkIDNumber.

Is there any way to create a query that will add all the possible skills automatically? I could then just tick the check box that they have used them. At the moment I am using a lookup which brings up the details when I type in the code but is very time consuming and I thoiught there must be an easier way.

Many thanks

Cath

 

[PHV]

You may consider an append query based on a cartesian product of skill table and coursework table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Remou]

Could you create a master SkillID and CourseworkIDNumber table? Then you could use an append query to add records for a student, selecting the group of records from the master table with such-and-such CourseworkIDNumber.