luggerite

Sorry, I should add that to always force 2 decimal places you need to either use a hidden calculation field that corrects the "Amount" as a properly formatted text string or use the following calculation in your field calculation: Text & " $" & Round(Amount;2) & Case(Position(Round(Amount;2);".";1;1) = 0;".00"; Position(Round(Amount;2);".";1;1) = Length(Round(Amount;2))-1;"0";"") Note I foolishly used "+" in my previous post when it should have been "&"..... :-(

There may be a better way, but I'd structure the calculation to format the number as it calculates: ie: Text + " $" + Round(Amount;2) where "Text" is your other text fields and "Amount" is your currency field.

Forgive me if this is self-evident or I've missed the answer trawling through the forum.... Is there any way to intercept the automated "Save changes to this record?" dialog in FMP9 to get it to trigger a script? Yes I know this would be easy in FMP10 with script triggers, but upgrading isn't an option currently. I need to be able to automatically record and track all changes/edits made to data in a database. Specifically, I need to: 1. Have a record of who has made a change 2. When they made it 3. What the change was.... I can set up a related table linked by the Record ID to create a new record when changes are made using a Commit Record script step manually triggered by a "Save changes" button which saves the modifiers account name and timestamp. However ideally I'd like it to do it automatically when the record is committed, and importantly, to record the change made, or at least the fields which were changed (up to 20 possible fields). Any ideas?