You'll need to tell us more about your database. You've told us you have three tables and that the relationships between them are based on Staff ID, but you haven't told us exactly which tables are linked to which. Also the "same setup on the holidays table" is too vague for us to tell what you are attempting to do and how your are attempting it? Provide and example that walks us through it step by step and illustrates how it fails.
You can document relationships by uploading a cropped screen shot of manage | database | Relationships or you can use text such as:
Staff::Staff ID = Times::StaffID
ok to try sorry
This conection one to many works it adds up the many shifts my staff work and puts a total into Staff::WeeklyTotal for all my Staff
This only reports the total holiday on the first memeber of Staff in the Staff table it dosent add all the remainging holidays up and insert the total in to the Staff::Holidays filed
Also i realy am new how do i do a screen shot on a Mac??
I'm a windows user so I forget the details on mac screen shots...
What dos one record in the Holiday table represent?
What type of field is Staff::Holiday?
one record oin the holiday table repesents one weeks of holidaysor part hoidays the shifts are added up and have a total in the one record.
All the fileds i am trying to add and the ones i have added are all time fileds as is the Filed Staff::Holiday
and i have a pic of the relationship now
I don't see any link between the data in the holiday table and the Staff::Holiday field.
If you want to see a total drawn from related records you need to use either a summary field defined in the holiday table or a calculation field defined in Staff::Holiday that uses Sum to total up the related records in the Holiday table.
In the Staff Table i have 2 calcualtion fileds that "Sum" the relevent filed in Time Clock Table renamed from "Times" and the same for the Holiday Table
Please post the calculation definition for that sum of data in the Holiday table.
First one is the holidays only works on the firat record in the Staff Table
Sum ( Holidays::HSumTotalHoursHol)
Next is the Time Clock works for all records
Sum ( Time Clock::TimeWorkedSum )
What kind of field is HSumTotalHoursHOL?
Put a portal to Holidays on your Staff layout. Do you see just one holiday record or all the holiday records that you expect to see for that member of your staff?
I see what i expect for the first member of staff but nothing for the rest
it is a calculated time filed
You DO expect each member of staff to have their own set of records in the holiday table?
Better check the values in StaffID in both tables to see why no other records in the holiday table match to a record in staff.
dam i thought that was it i didnt have a record in the Holidays Table for all the Staff but i do now and it has improved the sitution i now have 3 records in the Staff table updated but still not all
You'll have to explain that in more detail. What do you mean by "updated"? What are you updating and how?
Sorry by updated i mean the sum has worked for the first 3 of my staff records but then stops in that it doesnt put in any more results blank from then on.