Okay, cool.
So here is what you need to do:
- In your Trips table, create a Single Value column. This column should take “First → Whole Row” from your Vehicles table. Call this “svVehicles”
- Next in your Vehicles table, create a User Specific Text column. Call this “Selected Trip”
- Again in your Vehicles table, create a Single Value column. This one should take “First → Selected Trip” from the Vehicles table (ie. the previous column). Call this “svSelectedTrip”
- Now, on the list of Trips (your last screen shot), you need a custom action with two steps:
– Set Column Values → svVehicles → Selected Trip, setting that to the RowID of the selected trip
– Show Details Screen → This item - Once again in your Vehicles table, modify your Trip Request Connect relation column so that it matches the svSelectedTrip column with the RowID column in your Trips table. Check to ensure this is a single relation.
- If you’ve done all the above correctly, you should now be able to use a Set Column values on your Vehicles list that operates through the Trip Request Connect relation to set any column value in your Trips table