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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Selection dependent Checkbox group

Thread began 2/19/2013 6:16 pm by paul386190 | Last modified 2/21/2013 6:51 pm by paul386190 | 877 views | 2 replies

paul386190

Hi Jason, hope you're well.

I'm just picking up on the project I spoke of before, it has developed further than expected and not quite sure how to structure it to work with Relational Tables. I wonder if you can offer any advice.

Essentially I'm building Insert and Update pages for products. A product can be assigned to a number of different Devices, and some of these Devices can be within different Categories. For example..
PRODUCT - Blue case - is compatible with DEVICE iPhone 5 and DEVICE iPhone 4 which are both within CATEGORY Mobile.
PRODUCT - Red case - is compatible with DEVICE iPhone 5 in CATEGORY Mobile and with DEVICE iPod Mini in CATEGORY Audio

I've planned four tables...
CATEGORY containing CATEGORY_ID and CATEGORY_NAME
DEVICE containing DEVICE_ID, DEVICE_NAME and CATEGORY_ID
PRODUCT containing PRODUCT_ID, PRODUCT_NAME and countless other details
ProductDevice containing ProductDeviceID, ProductDeviceProductID and ProductDeviceDeviceID

On my insert page, for the user to be able to select any DEVICE in any CATEGORY I created a number of RecordSets that are all populated by the DEVICE table, but each one filtered by a different CATEGORY ID. I then followed the online 'Blue Sky Music' tutorial by having checkboxes within a Repeating Selection populated by the first device RecordSet, and then duplicated for all the other device Recordsets. I've attached a screen grab so you can see how each one is housed in a tabbed panel.

The problem I've found is that because I've had to split the DEVICES across a number of Repeat Selections, when I reach the stage of inserting the MRT into the Insert page and specifically the Options Table Join panel it lists all the Repeat Selections separately when ideally I need to be able to select them all seeing as they are all populated by the same database table.
Do I need to structure the database differently or maybe the page to be able to work with the MRT? I had originally hoped that I could set up several MRTs on one page, but noticed in another forum post that this isn't possible.

I would be very grateful for any advice you can offer.
Many thanks in advance and kind regards
Paul

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