Microsoft Access Forum

Access Forum

Table Structure Upload Images Link
Stephen Blazo
12 months ago

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
12 months 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
12 months 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
12 months 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.

Dan Jackson
12 months ago

Many-to-Many

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Forum Comments

Subscribe to Access Forum
Get notifications when this page is updated