Calculating across records for a given field

[iago]

Let me premise that I have very little experience with FM, so if my question is too obvious please do not hesitate in referring me to the instructions.

Here goes: I am making, say, a database for cheese. Each cheese has different sales in different countries. I want an user to be able, for each cheese (record) to select countries from a value list, and then insert figures next to the chosen countries. This bit I should be able to do.

However, I then wish to be able to make a calculation of, say, how much all my cheeses sold for in france. I need to run something like a calculation field, that calculates across records, in a given field. What is not so simple to me is that the, say, France field, which is selected from a value list, is as far as I know unconnected to the figure placed next to it. It may be elementary, but I just can't see how to do this. If anyone can, Many Thanks.

Jan

[Slobey]

If you only have one table in your DB. you can make a self joined relationship. relate country to country. Then make a calculation field.

sum(self relation::figures)

This is a basic option. Not knowing all the details of your DB.