AnsweredAssumed Answered

Relationships in database

Question asked by PaulLawrence on Aug 8, 2011
Latest reply on Aug 8, 2011 by PaulLawrence


Relationships in database


I've created the following database with a join table.

I wanted the join table to accumulate employee vs. date information.

I wanted to be able to view the dates associated with individual employees. (Works fine.)

I wanted to be able to view the employees associated with any date. (Works with some problems.)

To  make it work, I chose to create the Date table with unique primary key that is the date.


This relationship with the date table seems unwieldy. Am I making a rookie mistake?

Do you have a suggestion for a better way to handle the dates in the join table without having this separate Date table for the relationship?