Using Data Assist to access Recordset
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