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

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.

Thanks for the input