Richard, Ive been tracking our cattle herd for about two years now. Im struggling with how to set up a weigh table structure. Each cow is tagged and some individual characteristics tracked, thats the easy part. We weigh each cow about four times a year. Ive tried keeping a separate weigh table as well as combined with the cow table. Problem is I have to add a new field each time they are weighed. I havent solved an easy way to update my queries each time I add a new weigh date and weights. We dont know ahead of time when the weigh dates will occur. Any advice would be appreciated. Steve Blazo Sherman, TX
Adam Schwanz 8 days ago
Sounds like you just need a table with WeightID, CowID, WeightDate, Weight and then you can add as many records as you want
WeightID CowID WeightDate Weight
1 1 5-1-22 2000
2 1 6-1-22 2100
3 1 9-1-22 2150
A Glenn Yesner 8 days ago
Have a Cattle table (CattleT) and each cow has a unique number. Then a Weight table (WeightT) (AutoID, CowNumber, date, weight, etc.) with a foreign key that relates to the unique number of each animal (you can track weight over the years). You can do a separate table for medications (MedT) and veterinarian care (VetT), just tie the foreign key in each of those tables to the unique number of the cow in the Cattle table.
Stephen Blazo 8 days ago
Thanks Glenn and Adam. Virtually the same answer guys. I'm working on a weigh table as you have suggested. Thanks again for the super quick responses.