Hi,

I am not exactly sure how to phrase this question because I am not

entirely sure of the direction I need to take this problem.

Basically, I am looking for a way (either using scripts or calculation

and summaries)to get a subsummary of a field, and then use that data

for further calculations. If this sounds like familiar territory

please read on.

Each record in my file has a "person name" field, a "project name"

field and a "hours worked" field. How can I get the total number of

hours worked per project per person in a way that I can use those

numbers in another file. I can get it to display those numbers using

sub-summaries and a summary field, but I cannot tell the computer to

get the data from those sub-summaries.

Hope I made some sense, I am a beginner to moderate filemaker user and a very knowledgable computer person

thanks in advance for any help

Nate

You need an self relationship based on fields person and project (better approach would be personID and projectID, but anyway the principle is the same).

first create an stored calculation field result text:

multikey=personID & " " & projectID & "

Hi,

Thanks for the advice. I have to correct myself. I should have written that I am trying to use the data from the hours worked per person per project in another (sub-summary) layout which is sorted by name. Hopefully it will look like a spread sheet with names listed on the left and projects (slected from a conditional value list) on the top. Then the hours worked per person per project would be located at the proper intersections on the spreadsheet layout. In all honesty I'm not used to working with complex relationships so Ido not entirely understand what you describe in the last post. Sorry, if I just made things more confusing... I'm sure my description is a little verbose.

Nate