Populate field in child table from parent table

[tvinci]

The images table is a child of the delineatedLocations table.

When someone uploads a picture to the images table, I would like the Name, Driver, and Route fields to be populated with values from the delineatedLocations table that correspond to that location.

How do I do this?

Thank you

[LeventK]

How your images table connected to delineatedLocations table? If it’s a reverse ref, you can create a Virtual Column with REF type to your delineatedLocations table and you can then you can de-ref the column values from parent. If it’s not reverse ref, than you can simply de-ref the values.

[tvinci]

Okay so what you’re saying is that I create a virtual column in images with this formula:

And then how do I “de-ref the column values from parent?”

[LeventK]

@tvinci

help.appsheet.com

Dereference Expressions

Use a dereference expression to retrieve a field value from a referenced record.

[tvinci]

Thank you LeventK. I tried what you suggested but I don’t know why it’s not working. I even tried looking at the sample app.