Hi again Trygve -
Running scripts in response to events is difficult in FMPro. There are plug-ins
that can do it, but they add overhead and I wouldn't recommend trying to run a
script every time any record is modified. With that said, are you aware that
you can use a universal relationship (between indexed, non-global fields in each
database which ALWAYS have the same value in every record) to pull data from
globals to any database with the Set Field step? It sounds as if this method,
sometimes detailed in the group, might be appropriate to what you are trying to
do. I admit, though, that even after all these posts your solution's design
remains something of a mystery to me. I hope this hint helps you to make
Best of Luck -
> I think I found a solution to my problem, but it creates a new (smaller I
> hope) problem.
> I have a couple fields in one database, whose contents need to be copied to
> two globals in another database (which in turn uses these values to
> establish a relationship, which sums values in a related database, and
> finally passes this sum to the original database via a portal).
> I need to keep the globals in the distant database in synch with the current
> record's settings in the main database.
> I have a script that sets these values. Is there a way to force this script
> to run when the current record changes to a different record or when one of
> the fields is changed?
> I can't "pull" the data into the Globals because there is no 1:1
> relationship, so the data must be "pushed" into the global.
Don't forget to remove the obvious spam block when replying.
I advocate making an address book entry and using it! Thanks!