close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Parent / Child from same table?

Thread began 12/10/2014 2:17 pm by iain331081 | Last modified 12/11/2014 1:00 pm by Jason Byrnes | 833 views | 7 replies |

iain331081

Parent / Child from same table?

In the past I've done this using a one to many relationship - continents and countries. So any given continent will have multiple countries, so it makes sense to use a continents table and a countries table.

I have a case here where its a one to one relationship - categories and category orders. Really its a means to an end to allow sorting in something other than A-Z or by unique ID.

In which case is it possible to have a single table for categories:

Category_ID
Category
Category_Order

Where Category can be the Parent, and Category_Order be the Child?

Really just to automate the selection of Category_Order when a user adds a new Category using the dynamic dropdowns.

Hope that makes sense!

Sign in to reply to this post

Jason ByrnesWebAssist

yes, use 2 recordset, one to populate the parent table and set category to be the value and the label

the second will be used in the Create Dynamic Array, set the parent ID to category and the child ID and Label to use the category order column.


when you apply the Populate list from array behavior, you will need to edit the code to add single quotes around the parent ID value since that is expected to be a number, but that should be the only change needed.

Sign in to reply to this post

iain331081

Thanks Jason - I've made a few changes to the database structure to try it out and have the drop downs working nicely on my add and update keyword pages as I would like. So most of it amended quite painlessly.

The one thing I haven't gotten quite right though are the behaviours on the <body> tag to get the two dropdowns to display the current values of the keyword being updated.

I have attached the page as it is, with more details below.

Sign in to reply to this post

Jason ByrnesWebAssist

Looks like the value being saved to the database for the category by the insert is the ID, so in the parent list, set the value to use the parent ID, and in the Create Dynamic Array behavior, you will also need to use the category ID column for the parent ID.

Sign in to reply to this post

iain331081

Sorry Jason - have tried changing that, but still going wrong somewhere. Could you have a look at the version on the server? Thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

the parent list is still set to use the Category name columns for the value. it looks like on the insert page, the category ID is being used for the value, you need to set that up the same way on both pages.

Sign in to reply to this post

iain331081

Thank Jason - I got that all working in the end. Had just gotten a bit confused with all the the IDs and different behaviours kicking around.

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

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