>A basket could have a variety (combination) of PlantNames in it.
> PlantTable will have field PlantName and field PlantName.pic (attachment).
[quoted text clipped - 21 lines]
> ......this is where I get stuck. I don't know that Access will do what I
> am envisioning. I am grateful for any help. Thanks, Les
Jeanette,
Thank you for looking at this.
I plant several hundred hanging baskets each spring. Many are planted with
4, 5, or 6 cuttings/seedlings of the same kind of plant (monoculture).
However mixed baskets are planted also. Pictures can be found for all the
varieties of plants I use with the mixed baskets.
I am hoping, with Access DB, to bring up a form which will allow selecting
the 4, 5, or 6 cuttings from a group of several types and colors of plants.
Three such selections might be:
10 - Basket1 - 2red, 2blue (2varieties, 4plants total)
20 - Basket2 - 1red, 2blue, 1accent (3varieties, 4plants total)
10 - Basket3 - 2blue, 2yellow, 1accent (3varieties, 5plants total)
Ideally the form would show a picture of each variety of plant which makes
up the combination (Basket1 would show red.pic and blue.pic, Basket2 would
show red.pic, blue.pic and accent.pic etc.). I figured separate combo boxes
would allow the selection of the plant (by name) to be used with the
combination basket. But I don't know enough about relationships and Accent
minutia to make it work as envisioned.
When I first started doing combination baskets, I would make them up as I
planted. Some where good looking and sold quickly. Just as likely though,
some would be pretty ugly in the end. I have tried to keep some order to
this process with a spread sheet, which is helpful. But thought Access could
better allow visual matching with the plant pictures. Also much more concise
reports to bring into the greenhouse when I plant.
I've search for templates, but nothing seems to be out there.
Thanks Again,
Les from Minnesota
> Les,
> I can see at least 4 tables.
[quoted text clipped - 49 lines]
>> ......this is where I get stuck. I don't know that Access will do what I
>> am envisioning. I am grateful for any help. Thanks, Les
Jeanette Cunningham - 08 Feb 2008 06:14 GMT
You could do this with Access. If you have Access 2007 it would be even
easier because you can store pictures in the tables. We can help with the
code as you need it. However be aware that it is quite a steep learning
curve and takes quite a while to learn how to use the forms, queries,
reports and VBA.
Jeanette Cunningham
> Jeanette,
> Thank you for looking at this.
[quoted text clipped - 83 lines]
>>> ......this is where I get stuck. I don't know that Access will do what I
>>> am envisioning. I am grateful for any help. Thanks, Les
Les - 09 Feb 2008 06:20 GMT
Jeanette,
Are these tables you suggested enough to get a combo box which would display
plant names and would allow selection of an attached picture? I can maybe
figure it out if I knew how to pass the tblPlant data and attached picture
on to a "Combinations" form.
Is this really complex, for I understand very little about Visual Basic. But
I am able to stumble along with Tables, Queries, Forms, and Reports.
Les
> You could do this with Access. If you have Access 2007 it would be even
> easier because you can store pictures in the tables. We can help with the
[quoted text clipped - 91 lines]
>>>> ......this is where I get stuck. I don't know that Access will do what
>>>> I am envisioning. I am grateful for any help. Thanks, Les
Jeanette Cunningham - 09 Feb 2008 11:52 GMT
The way I see the database,
the picture would be for reference - you could show the pictures on the form
where you choose the plants.
You would just pass the PlantID to the Combinations form.
The tables would be enough to store the combinations and how many of each
basket were assembled.
Jeanette Cunningham
> Jeanette,
> Are these tables you suggested enough to get a combo box which would
[quoted text clipped - 100 lines]
>>>>> ......this is where I get stuck. I don't know that Access will do what
>>>>> I am envisioning. I am grateful for any help. Thanks, Les