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 | 1116 views | 5 replies

10/02/2014 4:29 pmdavid

Is it possible to insert two new records wit one form when one record is dependant on info from the other new record?

So my problem is this: I need to have merchants be able to log in and check their stats. My DB has a merchant table with all of their info.and a separate table for users which is used for logging in. My question is how to create records simultaneously on both tables?

These are my thoughts: 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?

OR

Should I be looking at having a two login systems. One that retrieves data from from the user table and then have a separate login for merchants and just have their credentials stored on the merchant table?

OR

Can you give me a better more simple solution that my inexperience won't allow me to find?

Thanks Guys!

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.