I'll do that Isabell
Question first. I presume you wish to do this within one database?
Keeping it in one database means you can share the plants list, year on year.
In that case you could set up multiple gardeners, one for each year:
My Garden 2007
Upper Garden/Bed 1, Bed 2.....- Lower Garden/ Bed 1, Bed 2
I'm assuming again that Upper Garden and Lower Garden are divisions (is that your set up?)
My Garden 2008
Upper Garden/Bed 1, Bed 2.....- Lower Garden/ Bed 1, Bed 2
Crop rotation - plants in Bed 1 moved into Bed 2, bed 2 into bed 3 etc
At the beginning of 2009
Click Duplicate this Garden: ==>Enter text for name of new garden (e.g. My Garden 2009)
Program creates replication of My Garden 2008, with all the divisions and garden areas from 2008
For the recreation, Could give options to select all, deselect one or more etc
BUT, with NO plants in the beds at this stage.
Now to copy the plants:
Program will allow you to select:
Pop-up 1: My Garden 2007, My Garden 2008
Pop-up No 2: Upper Garden Bed 1, Upper Garden Bed 2, Upper Garden Bed 3 etc, Lower Garden Bed 1, Lower Garden Bed 2, Lower Garden Bed 3 etc
Once you've set the pop-ups, a list of plants in the selected bed will appear.
Options to select and deselect plants in the list, or select ALL
Then an option to select a destination (a garden area in the 2009 garden)
Click button, selected plants (from say Bed 4 2008) will be added to your selected bed in 2009 (e.g. Bed 1 2009)
Is that what you are after?