I'm an organic grower! Built a database to manage my garden, and each year, I add bits and pieces to it! Each year I get stuck!!! I'm really hoping to find help here!
Here's what I need to do:
I have a table that contains VEGETABLES and a related table that contains SPECIFIC TASKS that have to be done from the moment I sow that vegetable (fertilize, prune, transplant, so on!)
I also have a table named VARIETIES (for each vegetable, I sow several varieties.. example for tomatoes, I would have "italian" "cherry" etc etc
Each time I sow a variety, I create a BATCH with the date, the number of seeds that I've been sowing, and so on ( I make several batches of the same variety, most of the time!)
When I create a new BATCH, I would like to create automatically a list of RELATED TASKS with dates that would be calculated from the date that batch has been sown...
I don't know if I'm being clear... I made a graph to isolate the concerned tables...
I've been trying quite a few things with no success and I'm desperate to get this to work before the growing season starts!
I hope you can give me a hand with that!! Thanks so much!