Table linking via criteria

[RWG]

Have need to link to different tables from SQL and link one of them to a
front end access database. What I have is a table that lists the SQL table
names and queries to filter that list for the SQL table I need. I need help
getting access to link that SQL table to my current database. Process would
go like this.

Sales table - has data about a sale, customer id, campaign id, etc
Customer table - could be any one of several tables in the SQL database

Would select record from Sales table and have the system delete the old
customer table (already figured out that part) and link the appropriate table
from the SQL database that has the customer information.

Please help