I will look more into this but it does seem like I will have to do the new Table route. Will also just be a whole lot of work to redo all my Recordsets on all my current pages. I am using SQL Manager to do my Database with so I will need to figure this whole thing out a bit.
Will using only one table not make your site load longer because it has to now go through all the Items to find the correct products for the correct page instead of as we have it now where I just tell the page (Recordset) which table to look in and which ones not to?
How do I create a "view" in SQL Manager for MySQL if you know how to do it?