close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Working with multiple Database(s), multiple Table(s)

Thread began 4/07/2011 10:56 am by jalexander414479 | Last modified 4/07/2011 11:14 am by Jason Byrnes | 623 views | 1 replies |

jalexander414479

Working with multiple Database(s), multiple Table(s)

I just purchased the DA 2.0.8 Extension and ran thru the Wizard multiple times.. very nice.

But on the first page of the DA Wizard, I do not see any way to work with a Recordset, only a "single" Table?
- It only gives you the option to choose Database/Table
- I have multiple Database(s), each with multiple Table(s)
- How do I Reference or access the other Database(s) or Tables using DA?

In the past, I would create my Recordsets first, from multiple Table(s) then use this as the Source for my Forms..

I tried to go back and "change" the DA querysource after running the wizard, creating my full Recordset, including my other tables, but it crashes all of the pages..?

Question: What is the proper way to work with multiple tables and DA wizard?
Thanks,
ja

Sign in to reply to this post

Jason ByrnesWebAssist

In most cases, child tables are used as options for the parent, for example, take a products Database

you may have a products table and a categories table where the product can be assigned to the categories.

In the wizard, set the categories column to use a meny form elements type, then click the lightning bolt next to the menu to edit it;s properties, and set it to use the categories table, with the category ID as the value and category name as the label.

If you have a more complex table structure, you may need to build on the pages after the wizard has been created, for example adding the Manage Relational Table behavior to the insert and update behaviors if you have a linking table.

Sign in to reply to this post

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...