Best method of entering multiple similar new individual records from a list in related DB
sorry if this question is rather stupid...I am very new at this database stuff.
I have two related files containing records of cows. one is a record of everything a cow does, the other is its medical history. occasionally a whole group of cows in a field may have a medical treatment, a vaccination for instance, and this must be individually recorded in the medical record.
what would be the best approach to automate this process? the only variable is the ID of the cow which could be looked up from the field list in the cow records to create a new medical record entry, the treatment in the medical record would be the same for all animals