many-many many (1 Viewer)

[titus]

I know how to do a many-many with a junction table but i have a database for tracking job interviews...

1. job opening info
2. appplicants general info
3. applicants status for the job

one applicant - job opening is many-many

Q- what to do with the applicant status table? this info is unique to the applicant BUT only for a specific Job opening.

 

[namliam]

Pretty easy

To resolve the Many-many you have to make a junction table anyway.

tblJob
JobNumber (key)

tblApplication
ApplicationNumber (Key)

tblJobApplication
Jobnumber (Foreign Key)
Applicationnumber (Foreign Key)
(Above two make the key for this table)
ApplicationStatus