Pictures on forms selected by combo box

[Les]

A basket could have a variety (combination) of PlantNames in it.
PlantTable will have field PlantName and field PlantName.pic (attachment).
I would like to select these plant.pics with a form and keep each specific
combination in an access database.

I am visualising being able to generate a report which lists how many of
each combinations and it's contents.
3 - Basket1
1 Red / 2 Blue
10 - Basket2
2 Red / 1 Yellow
5 - Basket3
1 Red / 1 Blue / 1 Yellow

PlantTbl: (PlantName / .pic)
Redplant with attachment red.pic
Blueplant with attachment blue.pic
Yellowplant with attach yellow.pic

BasketTbl: ( quantity / ...... )
the data in BasketTbl would be generated by the specific selections for
each combination.

.......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]

Les,
I can see at least 4 tables.
It seems a bit simplistic, is it part of a bigger plan?
What else are you going to want to do with this data?


tblPlants
PlantID >> primary key autonumber
PlantName
PlantPicFileName
PlantPicPath

tblBasketType
BasketTypeID >> primary key autonumber
BasketName

tblCombinations
BasketTypeID >> foreign key 1 to many
PlantID >> foreign key 1 to many
NumberRequired

tblBasketUnits
BasketUnitID >> primary key
BasketTypeID >>foreign key 1 to many
ProductionDate


Jeanette Cunningham

 

[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

 

[Jeanette Cunningham]

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

 

[Les]

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

 

[Jeanette Cunningham]

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