Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Your tutorial Dynamic Dropdowns with Data Bridge 2.0 is not working with my project. The reason seems to be the database structure.

View all replies to this thread

Your tutorial Dynamic Dropdowns with Data Bridge 2.0 is not working with my project. The reason seems to be the database structure.

Thread began 3/01/2019 3:36 am by Jonas | Last modified 3/12/2019 4:15 pm by Jonas | 496 views | 5 replies

3/01/2019 3:36 amJonas

The tutorial Dynamic Dropdowns with Data Bridge 2.0 is not working with my project. The reason seems to be the database structure.

I have tried to start from your tutorial Dynamic Dropdowns with Data Bridge 2.0 to create a corresponding dynamic dropdown for my project.

But its not working. The reason seems to be the structure that the tables in the tutorials have.

It does not feel realistic given the normalization of databases to have two tables with the same content in. As in your case where the cities name is in text in both tables.

The more logical here is, I guess - is that the field 'teamTown' in the table 'teams' instead contains a number that refers to the corresponding field 'townName' in the table 'towns'. That's how my database is built.

See the attached picture of how my structure looks.

How do I create a dynamic dropdown in this case?

I guess I need to change the code from step 2: Define child page recordset, in the tutorial in someway, but I don't know how?

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.