Payroll Database not working

January 28, 200817 yr

I had originally set up in Filemaker 7 a payroll DB for my business that was working fine. My business was just starting out so I only needed to tables Employees and Payroll. My business has now grown & I need a more detailed payroll. It seemed fairly straight forward but when I went to enter more records I couldn't get it to work properly.

My business now has 3 different profit centres, some employees work only in 1 profit centre, some work in all 3 profit centres. I want the db to track the hours worked in each profit centre so I can set up reports to expense the actual time worked to the appropriate business.

In the new DB I set up 4 Tables, Employees, Payroll #1,Payroll #2,and 3. My relationship for all tables is Employee ID.Each table has the same type of fields such as Sunday_Hr_Wk_1, Mon_Hr_Wk_1, etc for each day of the week and the same for week 2 (Biweekly payroll)All tables have the same calculation fields to add up the hours and calculate the pay.

When I created new records for each person in the first payperiod everything seemed to be good. The problem is now in the second payperiod when I enter new records for each person the hours for the previous payperiod are showing up after the new record has been committed. For instance in the second payperiod I entered the new record for John, he had 30 hr. in week 1 and 0 hrs in week 2, (in the first payperiod he had 10 hr in week 2)When I committed this record to go on to the next record, when I went back to John's record in the second payperiod he now has 30Hr in week 1 and 10hr in week 2, I deleted the 10hr in payperiod 2 and it was also deleted from payperiod 1. In the relationship options I have gone back and forth with changing the "allow creation of records" "allow deletion of records" this does not make any difference, inorder to enter information I have to "allow creation of records" I'm stumped, I don't know what else to do except put all the fields in the same table as I had before. Can anyone please tell me what I may be doing wrong. At this particular time I only need to utilize "Payroll #1 and Payroll #2, the 3rd one won't be needed until the summer, but if the first 2 are not working, I'm sure the 3rd one won't work. Any help would be most appreciated.