im a new programer and im doing a data base on MySQL with phpmyadmin, and i have this doubt, i know that if you want to link two differente tables, you need an attribute that is a Primary Key, and another in the other table that is a Foreign Key, but in this particular case, i want to link a normal attribute from one table to another, something like this:
Table 1: id (PK), age, birthday, name, Charge;
Table 2: id( PK), department, name, Charge (Reference);
So i can, for example, introduce the "charge" value to the first table, and then, when i visit the table 2, it would have that value as it was a FK calling a PK, or in other case, a way where i can link the PK of the table 1 with the table 2, so i can bring any attribute to it that i want like this:
Table 1: id1 (PK), age, birthday, name, Charge;
Table 2: id2, id2 (FK), department, name, Charge (Reference);
Is there any way to make this?