Add record from each entry in table for each user in another table

  • Thread starter Thread starter Steve Wood
  • Start date Start date
S

Steve Wood

I need to find a way to add details of a mandatory training course from one
table thats updated by the db manager to a table with each users training
history. Using a table that lists all users.

So thats three tables as follows

tblMandatoryTraining (This is the list of Training courses the manager can
update)
tblTrainingHistory (This is a list of all training all users needs to
accomplish)
tblUsers (This is just a list of users)

There needs to be an entry for each course for each user as they then update
the record to say they have completed it..

Any help would be appreciated as I just cant get my head arround this one.
 
I need to find a way to add details of a mandatory training course from one
table thats updated by the db manager to a table with each users training
history. Using a table that lists all users.

So thats three tables as follows

tblMandatoryTraining (This is the list of Training courses the manager can
update)
tblTrainingHistory (This is a list of all training all users needs to
accomplish)
tblUsers (This is just a list of users)

There needs to be an entry for each course for each user as they then update
the record to say they have completed it..
Click to expand...

Nothing to it.
create a query based on tblMandatoryTraining to select the records you
want to create records for.
Add tblUsers and filter for the users you want. Do not join the
tables (you can't really - the joins won't make sense, since the
tables are not directly related.) If you run the table, you'll get a
cross join - all possible combinations of the two filtered results.
So say tblMandatoryTraining has 3 records and tblUsers has 2 records,
your result will have 6.

Then take that query and turn it into an append query (to
tblTrainingHistory), and you're done.
 
Back
Top