How to select drop down values from another table?

[entomophile]

I have my main data entry form "Records" with a column for "Site Number".  I have a second table "Sites" with columns "Site Number" and "Site Name".

Currently I have a dropdown with the list of site numbers that will enter the number into the Site Number column of the "Records" form.

What I want in the app, is for the user to see a dropdown list from the "Site Names" column of the "Sites" table, but I want the "Site Number" entered into the "Records" table.  In other words, I want the user to see the site names, but have the app enter the site numbers into the Records table.

I have been playing with SELECT, LOOKUP, and VALID_IF but can't seem to get it right.

[Aurelien · Accepted solution]

Hi @entomophile 

In your "Records" table, you have a column "Site Number".

Please set this column with type Ref, and select the source table "Sites".

LAST STEP: the one you are probably missing 🙂

In your table "Site", set the Label property on the "Site name".

For reference: 

References between tables - AppSheet Help

Columns: The Essentials - AppSheet Help

Add row labels - AppSheet Help

[entomophile]

You are correct!  I was missing that last step.  I was making it way more complicated than I needed to.  Thank you!