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.