using a linked table
I was wondering what Jason or someone else from WA support think about using a holding table in mysql for using to query instead of using long queries in database?
basically i have 25 product tables and all have similar columns but not identical that is why i sperated into seperate tables.
however i though of using a table called "products" and using this to hold the "refid" and "userid" and "clientid" all in the one table along with "date" & "commission" columns for simple data retrieval to use with data assist repeat tables and dynamic web charts.
would you recommend this?