By the way. This is the LEFT JOIN I am using to get all the data into a results page, repeating region and search. This seems to be working but I'm not sure it's the proper way.
LEFT JOIN productcategories ON products.ProductCategoryID=productcategories.CategoryID
LEFT JOIN RelSubCategories ON products.ProductID=RelSubCategories.ProdSubProdID
ORDER BY products.ProductName
This joins the main "products" table, the "productscategories" table and the "RelSubCategories" table.
Basically it selects everything from the products table and then joins the CategoryName column in the productscategories table to the ProductCategoryID column in the products table in the first part. And the ProductID to the SubCategories in the the second part.
Is this at all correct?
In the case of the Sub Categories, there may be more than one for each record. So I still need to figure out how to display that. Right now it just shows two of the same record (If two subs are assigned) in the repeat region with the Sub Category ID being the only difference between the two.
One last questions. For the Update and Delete for this type of setup. Do I add a second delete behavior to remove the data for the relational table at the same time the deleted record is removed from the first table?