Hi,

I've declared some fields as auto-enter (with a calculation, replacing set to yes).

I want to force the refresh of the auto-enter calculation.

In FM6, I think, I was able to do it with relookup, but I doesn't seems to work anymore.

I've found out that you can use eplace fileds by themselves but you have to do it fo each field. So If you have 15 fields, Filemaker will loop 15 times !

I'm looking for a solution that would make Filemaker to scan only one time the records (1 loop).

I know I could use Loops with multiple set fields but thats too slow

Thanks

I want to force the refresh of the auto-enter calculation.

Auto-Enter (Replace) does indeed refresh automatically when any field in which it references has changed. But the referenced fields must be within the same table. Are the calculations pointing to related fields, Get() functions or aggregate functions? You haven't described the calculations so this is guess-work on our part to offer suggestions.

One thing you can do is pull use a Modification timestamp within the calc to trigger a change whenever anything changes in a record (within the same table of dependencies). What is your calc? Is this imported data that you didn't select 'Perform Auto-Enter"? We need more information. I have read that setting an ID to itself with force refresh through all Auto-Enter but I've never had to do it.

L

I have a project underway that uses auto-enter calculations that refer to fields from other tables. When I faced the same problem, i.e. changing values in fields from foreign tables and then needing my auto-enter calc to update, I incorporated the S4HU EventScript plug-in to trigger an update upon exiting the foreign field. It works, but I'm watching it carefully because it acted a little buggy when I first wrote the script...I had to do a Halt Script at the end even though there was no apparent reason for it to keep running. Also, I get a little screen-flicker when I tab out of the field.

If there's a better way to update auto-enter calcs when making changes to foreign fields, I'd like to know.

Yes, in fact it's a concatenation of several fields from another table.

I resolved the issue by doing a replace. Hopefully I can now when fields of the related table are chnaged because.

Thanks for the help, but I'm pretty sure it did work in FMP 6. That's strange to have to go back

More generally, is there a way to recalculate several fields at once, rather than having to do multiple replaces ?

Never tried this but ...

define a global = zero and add it to each of your auto-enter calcs then do 1 (one) relookup on the global.

OR

leave the 'Do not replace existing value for field (if any)' option unchecked.

Edited November 1, 200520 yr by Guest