Copy Tables and Create Links with SQL Backend

[_JSincliar]

I have 2 tables, A and B, in a 1-1 relationship and on an SQL backend.
With my Access front end, I would like to be able to make renamed copies of these tables on SQL, create the 1-1 relationship between the copies, and link them down to my front end.

To make the copy, I was going to use:

SELECT *
INTO CopyA
FROM A

But I'm not sure how to go about creating the relationship on SQL and linking the new tables to Access.

Thanks,
Jonathan