View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Inserting records into Multiple Tables at one with DataAssist is this possible

Thread began 8/24/2009 6:58 am by neil.batchelor254136 | Last modified 10/07/2009 3:33 pm by neil.batchelor254136 | 4393 views | 19 replies

Eric Mittman

The user id that you would have in any table other than the user's table would technicallly be a foreign key, but it is not necessary to define this in the table, you can just have it be another column in the table.

How you go about associating a record with a user is to ensure that your login server behavior is storing the userID in a session variable. When you insert a record into a table where you want also record the user you will use the DataAssist insert server behavior, in the list of column select the userID column in this table and use the lightning bolt icon to associate this field with your userID session variable. This goes for any table that you have the userID column added to associate those records with a particular user.

When it comes to updating and deleting after these pages are created by DataAssist you will want to update the recordsets on these pages. You will need to add in a where clause and say to make it select the records where the userID is equal to the session variable for the logged in user.

If you have any trouble with any part of this let us know and we can provide more info or details depending on what you need.

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...