I've recently added a field to my database which is calculated from two already existing fields (let's call them field A and field :. I added the new field to a layout, but it (the new field) comes up empty in all records. It will populate itself if I make a change to either A or B, but I'd rather not have to do this for every single record in this layout.

Is there to make FMP automatically populate a new calculated field?

Thanks in advance-- RC

Edited July 30, 200817 yr by Guest

It's sounds like we're talking about a field with and auto-entry calculation, not a calculated field. You could do a Replace using the field's AE calc to populate it; or you could do a Replace on the A or B field using itself as the calc. Be careful with the latter method or you could lose all the data in that field.

You're right, it's an auto-entry with a calculated value, not a calculation field. I switch the type to calculation and now everything works the way I wanted it to.

I had always figured that a calculated field meant a field with a calculated value, thanks for pointing out the difference.

-- RC