Expand my Community achievements bar.

Insert update records into multiple SQL DB table

Avatar

Level 1

Hi all,

Really hope someone over here will be kind enough to give me some guidance on this.

I've followed Stefan's tutorial as per below link:

http://forms.stefcameron.com/2006/12/18/databases-inserting-updating-and-deleting-records/

I have no issue in getting it to work. However, I'm trying to connect to 2 DB tables at the same time.

When I click the submit button, it updates the 1st table and creates a new entry in the 2nd table for tracking purposes.

I've tried creating 2 "Database" script object and renamed all the variables in the 2nd script object but I still can't get it to work.

Any ideas?

0 Replies