How to access information from another table

[Igor_Gabrig]

Hi guys!

I would like to know how I can access some information in another table?

For example: I need to register an employee in table “A”, but there is information (more than one) in table “B” that I want to access and make available by Listing.

Can anyone help me know how to do this? So far I haven’t been able to access information from another table through the AppSheet.

[LeventK · Accepted solution]

Start from here:

Guide on How To Create a Community Post Tips & Tricks 💡

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

And continue from here:

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

Dropdown on a Ref Column

How to limit which values appear in your dropdown when updating a Ref column.

help.appsheet.com

Dropdown from Valid_If

How to create a dropdown that depends on a particular list of values.

help.appsheet.com

Dependent Dropdown

How to make a dropdown with choices that depend on the value selected in another dropdown.

help.appsheet.com

Dropdown from Simple List of Values

How to define an Enum or EnumList to make a dropdown.

help.appsheet.com

The "Lookup/Dropdown" Data Pattern

A classic data pattern used to help users pick values from a fixed list of options