I have a table of animals each with a unique ear mark. I also have a table of vaccination records. When adding new records to the vaccination table via a form i would like a validation check on weather the animal actually appears in the animal table or not with an appropriate error message. Please help.
Many thanks.
Many thanks.
