Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

 Home > Forums > Access
Access Forum
Stephen Blazo
14 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 14 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 14 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 14 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 14 months ago Many-to-Many

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

Start a NEW Conversation

Subscribe to Access Forum