Jump to content

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

By Anuviel
in Relationships

 Share

This topic is 6062 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Anuviel Proficient

Anuviel

Posted
Posted

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?

Link to comment
Share on other sites

This topic is 6062 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept