Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Need to create a new record in my merchant table while at the same time creating a new user which inserts the new merchantID in the user table?

View all replies to this thread

Need to create a new record in my merchant table while at the same time creating a new user which inserts the new merchantID in the user table?

Thread began 10/02/2014 4:29 pm by david | Last modified 10/06/2014 7:59 am by david | 1114 views | 5 replies

10/02/2014 5:10 pmJason ByrnesWebAssist

is it possible to create a form that will insert a record into merchant table, retrieve that unique ID and then create a user where the ID is placed in a column on the user table?

yes, use 2 Data Assist insert behaviors, In the data assist insert behavior, you can set the name of a session to save the inserted ID.

In the first insert behavior, make note of the session that will save the inserted ID, and use that session in the second insert behavior as the value for the relational column.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.