V8 Data Import - Related Fields Do NOT Display

[Stat Larry]

I've got a script that deletes a set of records from a table, then imports a new set of records from an external data file.

The imported data values include foreign keys to a related table. The layout from which the import is being executed displays a number of fields from the foreign record.

After import, the layout shows blanks for the related fields, despite the fact that the related record DOES have values in these fields. If I close FileMaker, then reopen FileMaker and return to the same record, THEN the foreign field values are displayed as expected.

I expected that the related fields would be resolved IMMEDIATELY when a new record is imported, but apparently I've misunderstood.

Can anyone enlighten me as to what is going on here?

[John Mark Osborne]

Have you tried the Refresh Window script step with the option to "flush cached join results"?

[Stat Larry]

John, your suggestion worked. I think I might owe you a cold one...

Thanks MUCH!