thanks for showing interest. there is no other unique data related to cow, tag numbers are unique to a large extent, out of 450 cows, there is are less then 10 instances of repetition. although i can make a composite key of tag + date of birth or tag number + calf's mother's tag number, but i am...
Hi,
I am making a new database on access for dairy farm to capture data on cows reproduction, milking, treatment, feeding etc. cows are identified by "ear tag numbers" by the doctors and in old database on excel. I can not use ear tag numbers for primary key, because they are repeated and needs...