Linking Two Table with different Field names but have same data values and types

[Bobby101]

I have two tables that I want to create a relationship with but they both have different field names. Even though the field names are different some have the same data values and types. Would I be able to create a relationship with these two table with the field names being different but have the same data values and types?

[pbaldy]

Yes, the data types matter, the names do not.

[Bobby101]

So I can create a relationship?

[pbaldy]

Have you tried?

[Bobby101]

Yes. No errors came up. Thank you!

[pbaldy]

Happy to help and welcome to the site by the way!