Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › Query Builder › Having problem to show Master and child table data

View all replies to this thread

Having problem to show Master and child table data

Thread began 4/15/2020 2:12 am by Rokon | Last modified 4/15/2020 10:31 am by Rokon | 785 views | 6 replies

4/15/2020 10:05 amRokon

Originally Said By: Ray Borduin

Use two recordsets and filter the child recordset with the id from the parent.

Then do a repeat region on the parent recordset on the page.

After that is applied, manually move the child recordset code inside of the repeat region for the parent.

Now add a repeat region for the child record set inside of the other repeat region.

I did like this but the problem arise that on the child it shows always the same record inside all the parent repeat like as below and not changing the books base on the Cat Name.

Cat Name A
- bookName1
- bookName 2
- bookName 3

Cat Name B
- bookName1
- bookName 2
- bookName 3

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.