AnsweredAssumed Answered

Relationships in database

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

Title

Relationships in database

Post

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.

QUESTION:

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?

TableRelationship.jpg

Outcomes