'Ref' - How to use effectively?

[Domearian]

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?

[Aurelien · Accepted solution]

Hi @Domearian 

Here are some explanations about this 🙂

Dereference expressions - AppSheet Help

Build list dereferences - AppSheet Help

Drop-down on a Ref column - AppSheet Help

[Domearian]

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

[Aurelien]

You are welcome, this is what the Community is made for 🙂

Have a great day