You came for advice but ignored it. Good luck.
Apologies if you think I IGNORED the advice.
I just came with a simple question, "How to link the fields of a Table with Another Table" and I got tons of advises and suggestions for the Data Normalization, the use of a PK and FK.
I was looking for a quick, simple and Smart way to simplify the Copying and paste of data from the query result of my Database to Another Table in that same Database. I repeatedly mentioned, I am not using Access for what Access actually using for and I am not at all worried about copying data from one Table to another as we are never going to keep this data in Access, we will delete the Access Database once we have prepared the Reports and Charts . I just need Access as a Temporary method to filter the data and get the data in Excel. Unfortunately, I guess the Seniors of this Forum understand my question incorrectly and I am begging apologies for this.
At the end of the day, I still don't know how to link the Fields from a Table with Another Table in the Same or a Different Database. But, I will find it. Because in the first reply you mentioned "You can do whatever you like in Access".
Thanks a lot Pat Hartman for your reply, and once again, I am sorry if you think I Ignored your Advice.
Have a wonderful Weekend