using a flag based on records

[smeyer56]

I want to create a flag so that if a field is used once for a record, it is only used once. IE if change receive is subtracted from gift certificates it is not also subtracted from cash. Right now change can be received from many payment types and each transaction can have multiple payment types but only one change received field. I want to create a flag that if change received is used once it is not used again but is reset for the next record.

Any ideas?
CR8.5

 

[Reebo99]

An example of data and expected results would be helpful.

Reebo
Scotland (Sunny with a Smile)

 

[Madawc]

If I've understood you correctly, you can have several payments for a single change received field. This could be handled by grouping using change received field and then use the last, via a total that selects last.

Re-reading your description, you could mean several possible payments in one record. In that case, I'd create a formula field which checks each possibly payment using a set of IF and ELSE statements, using the most suitable. A point to watch for would be whether unused fields are zero or null, you have to test for nulls using isnull(your.field), or else the formula field produces no output.

Madawc Williams
East Anglia
Great Britain