Not quite there, not all clear when it comes to relationships (IRL ones as well as those in FM :P). Simple Structure: Employee_Table Week_Table Week_Line_Items_Table Employee_Table contain

[Anuviel]

Not quite there, not all clear when it comes to relationships (IRL ones as well as those in FM ).

Simple Structure:

Employee_Table

Week_Table

Week_Line_Items_Table

Employee_Table contains Employee Name, ID and rate.

Week_Table contains Employee Name, ID, Week_Notes and some other fields.

Week_Line_Items_Table contains Employee Name, ID, Time_IN and Time_Out

They are related:

Employee_Table::ID = Week_Table::ID

Week_Table::Fkey = Week_Line_Items_Table::Fkey (that is where

I am wrong most likely)

What do I make the Fkey - what should be inside?