Update collection based on values of another collection

[KickingApps]

Seeking help updating a collection based on values of another collection.  So, I have 
colVehicles (glrVehicles)                     colReservations  (glrReservations)                                               

vehNumber                                         vehicleNumber

isAvailable  (T/F)                                    

**The above collections have additional columns but were not referenced here as they are not relevant

I need to updat colVehicles.isAvailabe to false if  vehNumber <>  vehicleNumber in colReservations table.

colVehicles will only have the vehNumber once, but will likely have 3-5 records. The same vehicle number could appear in the colReservations table multiple times.

If it appears in the colReservations table at least once, then isAvailable should be false.  The colReservations table could have many records. 

@timl @RandyHayes @wyotim 

Thanks, in advance!

[RandyHayes · Accepted solution]

@KickingApps 

How about something like this:

UpdateIf(colVehicles, !(vehNumber in colReservations), {isAvailable: false})

That should get you what you need..

[timl]

@KickingApps

I agree that @RandyHayes's formula should do the trick. If not, post back here!

[wyotim]

Late to the party, but @RandyHayes seems to have it covered! 

[KickingApps]

Not sure why I couldn't come up with that - but works like a charm!  Thank you; you all are awesome!