I’m wondering if you can help.
I have two tables ‘Vehicles’ (a list of all vehicles, their type etc) and another ‘Bookings’ (dates, booking purpose) that has a linked field to ‘Vehicles’ allowing me to link multiple vehicles to one type of booking (via the primary field, which is a vehicle identifier unique to each vehicle)
Having a separate table for bookings saves me from having to continuously make endless date columns for each new booking.
I need to build an automation that does the following
Booking Table Recognises when a new record has been created and completed (currently signalled through a manually selected checkbox, easy enough to do!)
Booking Table Searches the linked field and recognises the vehicles that have been linked
Vehicle Table Find the records for each of those linked vehicles
Vehicle Table Link the booking ID to the vehicle record under the ‘Bookings’ Column
Happy to use an extension if that will do the job. Thanks!