I’m building a database to run my farm better. I have three tables:
- ‘Catalogue’, where crop names, photos etc are kept
- ‘Planting log’ where I create a record each time I plant a crop (how much, where, planting dates, expected harvest window, and expected harvest per week in kg)
- ‘Harvest log’ where I record what crop I harvest, kg, and cost to customer
What I can’t seem to work out is how to link these three together. I would like a simple way of seeing Expected total harvest kg (from ‘Planting log’) minus kg harvested (from ‘Harvesting log’).
I often harvest the same crop weekly over months, so the total needs to look for the crop name and subtract each harvest from the Expected total harvest kg.
Basically - a quick way to see what’s in the field, taking into account what I expected harvest to be when planting and taking away from that kg number with each harvest recorded in the ‘Harvesting log’.