exporting data between tables

[millmaine]

I have an advertising task management solution that we developed some years ago and are now we are streamlining.

When an ad is planned a record is created in our "Media" table. When it is confirmed I want to automatically create a record in our "Design Tasks" table. The simplest way seemed to be to create a script that copied the relevant "Media" field contents and pasted them into relevant fields in a new record in"Design Tasks". However some of the target fields are required to be "not empty" (and we want to keep them like that), which causes the script to stall.

Any advice?

[Brian C]

Use the script step:

Commit Record/Request (No Dialog)

after you use your Set Field [] script steps.