Import records from table to table not behaving as expected.

[gerg nnud]

I am trying to copy selected line item records from one table to another as part of an intended 'recurring transactions' structure. For some reason if I perform a find on line items for that transaction and attempt to import into the recurring line items table it wants to import all records (12000) and not the found set (1-20) as I would expect. 

I have just conducted some tests with other databases to confirm I have an issue with this database only. The test databases would only import the found set from table to table as expected. Is my db corrupt or is there some setting somewhere thats changes this behaviour? Any help would be appreciated. FM13.

[comment]

Make sure the TO selected as the source table for the import is the same TO as the one associated with the layout where you perform the find.

[gerg nnud]

Thanks Comment for piping in.

I just tried a few more tests along those lines. I'm doing the 'find' by  a go to related record script step. I then do an import from that specific TO in another script step. So I just tried a manual import to the table that holds the portal but still all records, not the one related one. 

I have even tried using two unrelated tables within the db and a manual import attempt as another test with the same results (all records, not the found set). That works in any other db I have here. If I import from another db it works as expected, just not table to table in this db.

I have had this working at some stage in development, I have applied this technique on many occasions but it does seem something is mysteriously wrong. I have also tried recovering the db. No go. In all other respects the db seems healthy.

Any other thoughts?

[comment]

The Go to Related Record[] script step can show the related records in any layout of the base table - not necessarily a layout that is defined to show records from the specific TO used by the relationship.