Any way to replicate an upsert

[Sadler]

Hi,
I have a list/form which uses an upsert to pass records onto another table for additional processing, in turn these records will be passed on to another list. The list has a large number of elements, about 97 at last count, so when creating the second upsert I am just wondering if I have to go through the create upsert process and add all of the elements again or can I just copy and then modify the settings in the database for the form?

Carl

 

[cheesegrits]

I'm not entirely sure what you mean. Do you mean just creating a second upsert for a similar list? If so, and the elements are pretty much the same, just copy the element map from the first upsert to a text editor, and use global replace on the tablename prefixes etc.

 

[Sadler]

Resolved, thanks Hugh. I did what you suggested and simply copied the text from one field to another in the database with some modifications.
Cheers
Carl