how to create a new data relationship in Access

Show us the tables. We have no visibility to them otherwise.

Include the fields you want to include in your query.

Thank you.

George is right. We'd really need to see your table structure before anyone can give a specific answer.

That said, from the way you described it, I wonder if you're trying to copy data from one table into another when you may not need to. That's a very common beginner mistake.

For example, you might have a Customers table, an Orders table, and a Payments table. The Payments table usually doesn't need to store the customer's surname because it can get that information through the relationships. The only time I'd normally copy data like a name or address is if I wanted to preserve exactly what it was at the time of the order, such as the shipping address.

If you really do need to physically copy data from one table to another, that typically requires either an append/update query or some VBA code. Access won't automatically duplicate values between tables for you.

Before you get too much further with this database, I'd recommend spending a little time learning about table relationships and normalization. It will save you a lot of work and make your database much easier to maintain. Just search for "Microsoft Access relationships" or "Access normalization" and you'll find plenty of good tutorials. Once those concepts click, you'll find you need to copy data between tables far less often.

LLAP