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, 200818 yr by Guest

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.

Hi thanks for your reply

Here is the relationship as it stands

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

bump!

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

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?