Hi everyone,
I have a question that needs your help
I have data tables including User, Position, Department. You can see my pictures attached
Each “Department” will have their respective “Position”
When I create a new user in the “User” table. When I choose to enter a certain “Department” the corresponding “Position” is displayed by “Position Name”. However, when writing data I want to show the value of the column “ID_Pos” in the “User” table as the value “ID_Pos” in the table “Position”.
But currently, data is recording the “Position Name” value in the “Position” table for the “User” table.
How can I notice that the value in the “ID_Pos” column in the “User” table is the ID_Pos value in the “Position” table?
We wish your help!
Thanks so much
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |