I need to update a field with the results of a calculation every time I enter a record.
The destination field cannot be a calculated field because FMP does not allow indexes on calculated fields.
The destination field must be indexed because it is used for a portal.
Original entry $234.37 into Amount Paid.
Calculation Results will be 2 into Amount Category field since the amount is between $200 and $299.
The portal will show all payment processing rules for a payment in that amount range.