Forum Discussion

Frequent Visitor

8 years ago

Parent-Child relationship problem

Hello Guys, I have a problem I've been trying to tackle but to no avail. Problem: An employee can be transferred to a different supervisor in the middle of the month. 5/1 - 5/15 ...

ambient_88

Frequent Visitor

8 years ago

Hello,

Here's the link for the sample data.

https://drive.google.com/open?id=1w9h1X_irjQJAlCNJyDvDgLqO9zcZGZwn

As you can see, a person can be moved to a different supervisor within the month. With the way I have it set up right now, if a person moves to another team within the month, his/her score will transfer as well. We don't want that. The score under Supervisor A should stay under that supervisor.

I would appreciate if you can guide me as to how to design the data model for this. Right now I have two lookup tables (Employee and Date) and one data table (survey data).

Thank you.