Thanks for this info.
I've just given it a try by altering the SQL code in the recordset to be as follows:
SELECT Subcats.*, productscategories*
FROM Subcats
INNER JOIN productcategories ON Subcats.SubcatCategoryID = productcategories.CategoryID
ORDER BY Subcat ASC
When I click the test button in the record set dialogue I get the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM Subcats INNER JOIN productcategories ON Subcats.SubcatCategoryID = productc' at line 1
So I changed the SQL to be as follows:
SELECT *
FROM Subcats INNER JOIN productcategories ON Subcats.SubcatCategoryID = productcategories.CategoryID
ORDER BY Subcat ASC
ie. just altering the first line. I clicked the test button and I got the results but when I clicked ok to go out of the recordset dialogue I got the following error:
"Making this change would require changing code that is locked by a template or a translator. The change will be discarded."
Any ideas why this is happening?