If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I think I'm almost there...except for...
my table relations. From left to right:
"Employees" Payroll (PK: 1) Employee Work Status Rate "week" Payroll (FK: Many) month week (PK: 1) "dept" Week (FK: many) Dept Subdept Costcentre Standard timehalf double So each person has multiple weeks and each week has multiple departments. But I get the following message: "You cannot add or a change a record because a related record is required in table 'week'. Can someone enlighten me? |
Thread Tools | |
Display Modes | |
|
|