i have a query that makes a new table and renames (to that systems id, system#xxx_qty&loc) it when a new system is added. the new table tracks the quantities and location of parts for that new system, each system is unique. i also have a table (system id) that has a single feild that identifies...