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

Gary

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?

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.

How about

New field (calulation, number result)

num1 + num2

Lee

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.

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