Relationships of plant database

[Con]

I am working on a database for invoicing landscape plants. What I would like to do is to print a picture ,description, and care instructions of every plant that is on the invoice.

The question is, how would I set up the relationship between invoice, plant, picture, description, and care instructions? Also, there are maybe four sizes of Colorado Spruce that have four different item numbers but I only need one picture, one description (height, width, shape, fall color, etc.) and one set of care instructions to go with those four different item numbers. There may be only 20 different sets of care instructions for the 3,000 different plants. The plant table is large, with over 3,000 different plant_ID's (plants with different sizes to choose from).

I am a newbie so keep you answer simple. Any help in putting this relationship together would be greatly appreciated.

Thanks in advance.

[Kent Searight]

See the attached example. It's very basic but makes a good foundation upon which you can build.

NurseryDB.zip

[comment]

I thought the question was how to print only one spec per type of plant bought - when several can be of the same type.

ProductSpecs.fp7.zip

[Con]

Thanks a lot for all of the help. I changed the file so that it would look more like the layout I will have. I just have 2 questions.

• In the specification file, I have a unique "Type" field for every plant name but not product record. There are many plants with multiple Product_ID fields because of the product/size. Because I have thousands of plants records, is there a fast way to attach the "type" to the product.

• Second question. I would like to add "hardscape" (Pavers) product to the specification file. When I do that the fields totally change. I don't need Height, width, shape. But may need color, style, etc. How do I deal with this?

Again, thinks for all of the help. You guys are great.

ProductSpecs.fp7.zip

[comment]

I am not sure I understand. Would it be correct to say that for every Product, e.g. "Spruce, Colorado" there is ONE description (picture, color, style, care instructions etc.) and SEVERAL sizes (where every size has its own price)?

[Con]

Yes, Each plant/size (Colorado Spruce 2" BB) has its own Product_ID number. The plant, (Colorado Spruce) has one "Type"number. If you look at the Product table view, Colorado Spruce has 3 Product_ID numers with the same "Type" numebers.

Sugar Maple has 4 Product numbers but one "Type" number.

Thanks again

[comment]

OK, I think this template may be better suited for your needs.

ProductTypes.fp7.zip