Am i going about this all wrong???

[Muzicmn]

What i have here is a training db. It tracks training for the FAA. Problem is there are 6 teams of employees and not all teams get the same training items, sometimes everyone get it sometimes only team 1 and 3, etc...

i decided to do this with a check box so when the data entry person enters a new training item they simple check off which team is required to do this. Logistically, i am not sure this is the best way to do this. Whey i do a query for training items i need to qyery 6 fields instead of just one.

I just want some input so see if i am headed in the right direction with this

thanks

Ricky

 

[Pat Hartman]

Whenever you have more than one of something, you have many. So 6 in this case is many. 1-Many relationships require two tables to represent the data. But you actually have a many-to-many relationship which is just 2 1-many's. You have teams and you have training. Each needs its own table. Then you have the relation table which relates specific teams to specific training.

Once you have recreated your tables in the proper structure, you will find that your queries will get simpler. You will need to join separate tables though so just add the necessary tables or queries to the QBE grid and draw lines between the primary key and foreign key to join them.

Take a look at this Many-to-Many

 

[Muzicmn]

That makes sense... i will give it a try,

thanks Pat

Ricky

 

[Muzicmn]

Pat,

just one more quickie. By following your example and from what i understand from your post. The best way to assign the trainees to the training item is to use a subform instead of check boxes, is that correct?

Ricky

 

[Pat Hartman]

Yes, use a subform. To use checkboxes, you would need to de-normalize the structure.