Linking a record producer with multiple tables

[Mohammad8]

Hello,

I am assigned the task of creating a form where the user can enter data and then the data should be inserted into 2 tables at the same time. I tried to implement this using a record producer but this didn't work because a record producer is linked with only one table. Is there a way to link a record producer with more than 1 table? Or is there a different way to implement my task other than record producer?

Any help is highly appreciated.

[Mark Stanger · Accepted solution]

You can do this with a record producer script.  The record producer can work like it usually does with the table associated with it, then you could use the script to do a GlideRecord insert of the same information into the second table.

[rajasekar reddy]

Hi @Mark Stanger / @Mohammad8 ,

can you please share the glide record script you used to update second table