June 2, 200520 yr I need to have a script create records in a remote database. I'm sure its absolutely simple and I think i've even done it before, but I can't for the life of me remember how to do it. Thanks!
June 3, 200520 yr There are several ways to do this, depending on what kind of record(s) you need. If the files are related and there is only a 1 to 1 relationship, a simple Set Field relationship::fieldName script step will automatically create the record. If there is a 1 to many relationship to the remote file, or if the records in the remote file are not related to your local file, a Perform Script step that names a script in the remote file will work. Do your record creation in that script. Pass needed information via script parameters, or lookups, or whatever will work best under the circumstances.
Create an account or sign in to comment