I am trying to write a script to create an import process into a specific temp table. The data will then be manipulated and placed in the main table.

I have tried selecting a table (is there a function for this?) before I run the import function but all I get is the main table as a choice and all others are hidden. I have also tried a Perform Find on the temp table to try and select it but that did not work either.

Is there a way to explicity state which table to use for the import and delete all records command? I even made a relationship between the main table and the temp table, though I don't really want one.

The Perform Find might help but I can only see that there are set finds overall that have to be run through in order as opposed to specifying the find command per script without a dialog box. Below is my script as it is:

Perform Find[Restore]

Import Records[]



*Restore = Tournament Import::First Name[*]

Note: Had to remove other finds because it does not appear that the finds can be script specific

Thank for you any help.

-Cam

The import function works based on the active window/layout. So, to import records into the DestinationTable, in your script, first go to a layout based on the DestinationTable. Then import.

With regard to finds, you can script any sort of find you want. First you Enter Find Mode. Then you use Set Field to put whatever search criteria you want into the search form. Then you issue the Perform Find[No Dialog] command. If you don't use the Restore option, this gives you full control over the find criteria.

HTH,

David