Copy record from one file to another
I need a little help getting started here. I want to be able to copy one record from one file to another file and I'm not sure how to get started. I know that you can import records from other files, but I want to make sure I am only importing the one record I want by running a script in the file I'm pulling the record from. Currently, the files are linked via external data sources, but don't have any relationships. Is this pretty basic scripting or will it be very complicated?
Any tips are MUCH appreciated! :)