many to many relationship

[lynn atkinson]

I have a table containing employee name, address, and
telephone number employee ID (primary key). I have another
table containing information on applications for post with
a primary key of (selection ID).This creates a many to
many relationship ie one employee can apply for many posts
and a post can have many employees applying for it. WHat
should my join table contain to give me 2 many to one
relationships?

 

[Elliot Liffman]

You need a junction table. Create a new table, say tblPostApplications, with
felds for EmployeeID and SelectionID. tblEmployees is related one-to-many
on EmployeeID, tblPosts is related one-to-many on SelectionID.