Need help with adding multiple records

[Muzicmn]

I believe this can be done with a query, but am having problems with it.

What i have is a db with a table for employee another table for training items and a third table to tie them both together. These employees are divided into several "teams" (team 1, team 2 etc ...) The training items are assigned to some or all of the teams. ( i know that this is a many to many relationship and i believe that is where i get confused ) Now the problem. What i would like to do is have a form that will allow the user to assign a new training item to teams 4, 5 and 6 and have access automatically create a record in the table. Now that the 20 or so employees that are assigned these training items will have a record that the user can simply fill in a date when the training has been completed by the employee.

I believe what i am looking for is an append query. Is that right?? Have been playing with this one for awhile and have no luck so i would appreciate any help i can get on this one


thanks again

Ricky

 

[Muzicmn]

I should also mention that an additional problem is that each team has several employees assigned to it. I would like to create a record for each individual employee instead of one record per team.

What i have so far is a form to create a new training item and a continuous subform in it so the user can select which teams to assign the training to.

Dont know if i am being too specific or asking for too much but i would appreciate whatever help you guys can offer on this one

thanks again

 

[Mile-O]

You have a table with fields like Team1, Team2, Team3?

If so then you need to read up on normalization before you worry about queries and forms, etc.

 

[Muzicmn]

No, I have a table with employees and a field in this table called teams. Here i assign the employee to individual teams... Do you recommend i make a team table? I though of that at first but then though when an employee changes teams we would have to go to each individual team and reassign

 

[Mile-O]

Do you recommend i make a team table?

Since teams are completely different entities from employees and tables are supposed to represent different entities then, yes, I would recommend a team table.

I don't know whether you store team history for employees.

 

[Muzicmn]

ok,

i am off to try a different approach... will check back with you guys and let you know how it goes

thanks for the quick response