I have a script that imports data from an ODBC source that updates a record in an existing found set. There is one record in the table. It goes as follows. Go To Layout ["Globals-Data: (Globals

[fmsavey]

I have a script that imports data from an ODBC source that updates a record in an existing found set. There is one record in the table. It goes as follows.

Go To Layout ["Globals-Data: (Globals) ]

Show All Records

Import Records [No Diologue; DSN; Filemakerelite; Calculated SQL Text; etc. ]

Import Records [No Diologue; DSN; Filemakerelite; Calculated SQL Text; etc. ]

When I run this script it works as expected. It updates two fields in the record. Each import maps to different fields. The "import order" updates records in existing found set.

When I call this script from a "control script" that opens a new window just before it is called the import does not work. Does anyone have any ideas as to why this is happening?

Edited September 6, 2007 by Guest