move a single found set record to another file

[jhomer]

Apology i posted in the wrong area initially

I have recently made a table to contain info about Potential Customers which our sales reps profile... I want to make a script which will move basic info about said company(contactcode name address etc.) to our Contacts DB. Both tables are located in the same file. I guess my question is..Is it possible to move one record to another file without importing to a global variables table and then into the target table?

As of now I am prompting the user for the potential customer code via dialogue box, and performing a find which results in a single record found set. from here i need help.

thanks in advance for any help

[transpower]

If your Contacts table has the same structure as the Prospects table, then simply use the Export Records script step. If not, then use the SET FIELD script step.

[jhomer]

Thanks for the input