I am new to Coda and I am trying to build a Doc to help run my mobile business. I have 2 Main tables, Dogs and Clients. I also have several small tables ie, zones, grooming van, groom time etc that link mainly to the Dog Table to keep the drop downs consistent.
I have made a new table of available appointments, which contain some of the same data that is listed for each Dog on the Dog table. Example - Blue Zone, Van1, Bath Only. I would like to set up a select control to choose the dog and then have the Appointment table filter to show exact matches, based on the criteria in their particular record vs what is in the record in the appointment table.
Is something like this possible??.
If so I would then pick one off the filtered appointments and somehow assign that record in the appointment table to that dog showing it is booked.