Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Parent / Child from same table?

Parent / Child from same table?

Thread began 12/10/2014 11:17 am by iain331081 | Last modified 12/11/2014 10:00 am by Jason Byrnes | 2033 views | 7 replies |

12/10/2014 11:17 am | #1 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!

12/10/2014 11:25 am | #2 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.

12/10/2014 12:15 pm | #3 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.

12/10/2014 12:28 pm | #4 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.

12/10/2014 2:11 pm | #5 iain331081

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

12/10/2014 2:55 pm | #6 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.

12/11/2014 8:25 am | #7 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.

12/11/2014 10:00 am | #8 Jason ByrnesWebAssist

you're welcome.

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.