Simple question

[M.West]

Hi

As I am quite a novie in Access, I have a rather simple question.
But it would mean a lot to me if some could help me!

I am designing a database to store data of a combination of employees and trainingprograms.
In the table employees; each employee should be linked to multiple training programs.
And in the table training programs; each program should be linked to multiple employees.

Now the question is:
How can I put multiple ID's (f.e. of training programs) in one row of an employee and vice versa.
Can I just comma separate them in one record?



Your advice would be very much appreciated.

Thanks in advance.

[R_Badger]

Actually the trick is you dont!

What you do is have a junction table tbl_trg_allocation

Allocation_ID, Emp_ID , Trg_ID

you then use that to allocate employees to training.

Sounds like you could use a read on database normalization, a good guide to it is here

[M.West]

Actually the trick is you dont!

What you do is have a junction table tbl_trg_allocation

Allocation_ID, Emp_ID , Trg_ID

you then use that to allocate employees to training.

Sounds like you could use a read on database normalization, a good guide to it is here

Thank you.
Your answer got me set-up on learning more about many-to-many relationship.

The company I work for and European economy thanks you.