Using Data Assist to access Recordset

[tim383164]

I am building a large MySQL database structure with many linked tables (Primary / Foriegn Key). While going through the DataAssist wizzard, it will only allow me to use primary tables.

On my local testing PC where I have MySQL 5.1 installed, I created a "View". This view also appeared as a table that could be used through DA.

So is MySQL Views the only way for DA to access multi-table SQL? If so from what I have read, Dreamweaver doesn't support MySQL Views or Stored Procs

[Ray Borduin]

Yes, views are the only way to for DA to access muti-table sql in a single search, results, details chain... but you can connect multiple instances of DataAssist specifying the results page of the child to appear on the details page of the parent creating the relationship that way as well. Dreamweaver should support views as well, not sure about stored procs, but you could always hand code them in code view if you needed to.