Total cost script

[Brit-Flick]

Hey guys, I have no idea where to start with this one.

Basically I have a system which needs to be able to extract management information. I have a layout which I have setup with a Department value list, and the idea is that when I perform a find the total amount spent by that department so far is to appear in a field below. I tried a summary field but it wouldn't work at all.

The way the system works atm is a member of staff chooses which dept they belong to from a value list, they then go to a layout, enter their staff id and the course id and it is added to their record. Each course costs so much. I got the summary field to work out how much each person spends, but otherwise...

I'm open to any suggestions.

Thanks in advance

Edited February 14, 2008 by Guest

[mr_vodka]

If you can please post more info on the tables, and the current relationships that you have. A snap shot of your relationships graph would be great.

Its seems as thought you can do this easily with a summary report, but I am not too sure where the fields you have mentioned reside.

[Brit-Flick]

Hi thanks for your reply

Here is the relationship as it stands

All of the fields under "-----Hidden-----" are used in calculations/conditional formatting.

[Brit-Flick]

bump!

Sorry this is the last thing I need to do for my system.

[mr_vodka]

I am sorry. I am still not following. What is the layout that you are doing the find on? Are you using a global field to select your department?