Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Data Bridge General / Announcements › Dynamic Drop Down form

Dynamic Drop Down form

Thread began 8/14/2014 9:56 am by russb335115 | Last modified 8/14/2014 11:14 am by russb335115 | 888 views | 4 replies |

8/14/2014 9:56 am | #1 russb335115

Dynamic Drop Down form

Question!

Can I reference two Category IDs in one field in my database to reference two rows in another table?

Ex: FinishGroupID = 2,4 this will populate another drop down menu with the content from my PortsGroupID fields row 2 & 4

8/14/2014 10:32 am | #2 Jason ByrnesWebAssist

no, this is what is called a many to many relationship.

to create a many to many relationship, you need to use a linking table.

8/14/2014 10:37 am | #3 russb335115

Is there a tutorial for that?

8/14/2014 10:45 am | #4 Jason ByrnesWebAssist

no, but your initial question and the details you provide in the private message section kind of conflict with each other.

to accomplish what you are trying to do will take some fudging with the recordsets, and using concat() to concatenate the two id's. If you need help in setting this up, we can help through a premiere support appointment.

8/14/2014 11:14 am | #5 russb335115

Thanks, I'll set that up.

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.