Adding a values from another record

[Gary1478]

Is there an easy way to add "field A" from the previous record with "field B" from the current record being browsed? Thanks.

Gary

[Cabinetman]

Is there an easy way to add "field A" from the previous record with "field B" from the current record being browsed? Thanks.

Gary

Can you be a little more specific and give a short example?

[Gary1478]

I have 2 fields call num1 and num2. I would like to add the value in the num1 in previous record with the value in num2 in the current record. The result would go into a field called num3.

[Lee Smith]

How about

New field (calulation, number result)

num1 + num2

Lee

[comment]

You could try =

Let (

n = Get (RecordNumber)

;

Case ( n > 1 ; GetNthRecord ( num1 ; n - 1 ) ) + num2

)

However, it might be better if you explained why you need this and how it's going to be used. The term "previous record" is rather vague in Filemaker: it could be the previous record based on the current found set and sort order (as above), or something more permanent based on a relationship. An abstract answer to an abstract question is not necessarily going to be the best solution for the real problem behind it.

[bruceR]

And don't forget we have summary field with running total option.