Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Detail page combining input from two tables

Detail page combining input from two tables

Thread began 6/28/2010 7:57 am by jeffmg279672 | Last modified 7/12/2010 4:47 pm by jeffmg279672 | 2258 views | 7 replies

6/28/2010 7:57 amjeffmg279672

Detail page combining input from two tables

Hi. I've got a database set up with 2 tables - 1 contains details veterinary practices, the other contains reviews of those practices.
I've set up a search page which searches by location then outputs the results to a results page. This in turn links to a detail page in the usual way. What I want to do, though, is to have the detail page also show whatever reviews have been posted against the practice in the reviews table. I've set these up properly with foreign key, InnoDB etc etc. What I want to know is whether it's possible to do this using DataAssist and if you can point me in the direction either of a solution recipe, tutorial or anything else that will walk me through it. Thanks in advance.

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.