Linking Job Titles to Training Courses

[bizzy]

Hi,

I'm new to this forum so forgive me if this thread is in the wrong section.

I'm currently creating an OHS&W (Occupational Health Safety & Welfare) database. My boss has just requested if I can possibly have it so that when a Employee has a job title selected for them it automatically lists the courses that are required for that job.

Can anyone help me please?

Cheers

 

[neileg]

You have a many to many realtionship between job titles and courses. You will need to use a junction table. There's plenty of help in the forums about this if you do a search.

 

[bizzy]

Thanks Neil, have got it all working with a junction table.

Thanks again for your reply.

Bizzy