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
I believe you may wish to mention more details about how you are pulling values between the tables.
I believe you may also wish to take a look at the following articles and sample apps that explain referencing between tables and table key and label concepts
Hi Suvrutt_Gurjar,
Thanks for your support, Iโm watching the instructions from you
However, it still doesnโt seem right to my needs. I will do more research, if there is more problem, can I ask for your help?
Sure. In general, please continue to post your queries in the community. This great community can help you with the best possible approach.
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |