Hello! My apologies if this is a newbie question. I've been tasked with fixing some issues with our FM database, which means I am trying to learn how to use it. I have not been able to find a solution yet and not sure which topic it would fall under.
Our database:
We are a vet clinic. Each appointment has its own record, but each client may have more than one appointment. If we duplicate the appointment to save time on data entry, mistakes are often made to update information for the new appointment. Is there a way to have the client's information (address, phone, etc) populate in a new record when we type in their name or some other identifying info?
