I'm a new programmer and I'm doing a database on MySQL with phpmyadmin. I have this doubt - I know that if you want to link two different tables you need an attribute that is a Primary Key, and another in the other table that is a Foreign Key. 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?