'Ref' - How to use effectively?

AppSheet AppSheet Q&A
, , , ,
1

Hi All, I have 2 tables.

Table A records time in and out of vehicles. It has: TimeIn , Time Out, Vehicle Registration, Vehicle Model.

Table B Holds vehicle details. Vehicle Registration, Authorised, Vehicle Model.

Table A is referencing ‘Vehicle Registration’ from Table B.

Plan: When the user is creating an entry for table A, they select the vehicle registration from a drop down which is referencing Table B, I then want table A to automatically get the Vehicle Model from Table B where the Vehicle Registration is referenced.

I can’t find any help on that. Can anyone please help?

2

Hi @Domearian

Here are some explanations about this :slightly_smiling_face:

Dereference expressions - AppSheet Help

Build list dereferences - AppSheet Help

Drop-down on a Ref column - AppSheet Help

3 Likes
3

Aurelien, That is so simple. I can’t understand how I have managed to overlook it! Thanks for the uick response.

3 Likes
4

You are welcome, this is what the Community is made for :slightly_smiling_face:

Have a great day

2 Likes