Connect data between sheets together

[tdhuy]

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

[Suvrutt_Gurjar]

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

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

help.appsheet.com

Row Labels

How to determine which columns are prominently displayed in a view.

https://www.appsheet.com/samples/This-app-shows-the-difference-between-keys-and-row-labels?appGuidSt...

[tdhuy]

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?

[Suvrutt_Gurjar]

Sure. In general, please continue to post your queries in the community. This great community can help you with the best possible approach.