Calculation in Relational Database

[adamkarwowski]

hey guys just wanted to as a quick question.

i have a relational databse with one layout setup so i do not have to make multiple records for the same record(thanks andy for that one). i guess its kinda like a sub record but i am sure you guys know what i mean. that relational databse is a weekly progress report with hours completed for each week. i want those hours to be subtracted from a feild in the main DB and then calculated and displayed.

to quickly explain. hours required is on the primary DB

weekly progress report from relational DB contains how many they have completed for the week.

back to main DB to display how many remaining hours next to required.

the way that i have it is that it only subtracts from one week report and not the rest so it dosent work.

any hints or ideas would be tremendously appreciated.

[keshalyi]

Well, if you use the sum() function, it will give you a sum of the hours. As in:

Field1 - Sum(RelationshipToDB2:Field2)

If this still doesn't subtract EVERY value of Field2, they are probably not related correctly. Just draw a quick portal, and make sure EVERY record you want subtracted from the parent record is in there. You can delete it afterward, its just to confirm that you set up your relationship correctly.