Import Found Set from table in same file

[Andreas T.]

Hello.

I hit upon a snag that I didn't expect when I consolidated a multi file solution into one file.

Apparently, Filemaker 8.5 (and prob. 7 and 8) will always import all records regardless of the found set when the source file has more than one window open (or is closed).

As this is a single file solution, there will always be at least 2 windows open when I perform an import from another table with a found set. This in effect imports all the records.

I am trying to accomplish what used to be a simple thing: Import all line items from the order_lineitems to the invoice_lineitems table.

I suppose I can script around it, but I have the feeling that I am overlooking something and that there is a simpler way.

Anyone?

Cheers,

Andreas

[Andreas T.]

Found out this one myself.

One has to perform the import script from the source window and switch to the destination layout just before the import script step. Then the found set is remembered.

It will not work with the source in another window.

Cheers,

Andreas