query to select table based on another table feild value

[hyperionfall]

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 the system (multiple front ends). i need to make a query that will select the correct table (system#xxx_qty&loc) based on the field value of the system id table. any ideas?

thanks for the help guys