Very Computer

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.

Thanks,

Trygve

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
progress.

Best of Luck -
James

--
Don't forget to remove the obvious spam block when replying.
I advocate making an address book entry and using it!  Thanks!

Create a relationship between the databases in question by creating a field
(ex: "All Records" a numeric field) in both database and set auto enter to
1.
Whenever a new record is inserted into the database, each record will have
"All Records" equal to 1.  This will provide a relationship between the
files and you will have access to the global value via a script.

Leroy

Quote:> 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.

> Thanks,

> Trygve

Thanks for the help - it is coming together.

In my Job database I have two globals (Week and Employee). These need to
reflect the data in the Employee database...

EmployeeName (text field) Jobs::Employee needs to be the current record
EmployeeName from the Employee database.

Week in a global in both databases which just needs to be the same and is
easy to copy.

How can I pull the EmployeeName from the current Record into Jobs wi no
common relation?

I have thought about making EmployeeName in Employees a global which would
work, but... Then I'd have to make the database only 1 record and move the
real list of Employee names to another database.

Sorry if this is confusing - my system uses 15 databases and was built over
5 years. It works well in our company, but we (that is, I) am expanding it.

Thanks,

Trygve