AnsweredAssumed Answered

Should have been simple... but I'm stuck!

Question asked by stephaga on Mar 8, 2017
Latest reply on Mar 10, 2017 by stephaga

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!