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.