One entry to update multiple records
Hi .. I am setting up a database for a dog rescue. I have a list of dogs and a list of foster carers. I have a field in the dog form to assign a foster carer to that dog. Is there a way to automatically update the foster carer records to show the dogs name in their records.
At the moment I have to go into each record individually to update them.