multiple options

[bassmanfranc]

i am working with an order entry database and need to price out a product
that could possibly have as many as 75 options, each with an associated cost
that would increase a base unit cost.

I was wondering what would be the best way to go about setting up that
environment in access and how would the order entry form be best laid out?

I need to have the order record, show and archive the base unit as well as
the options chosen along with the final cost of the unit.

I was wondering if I needed to have a separate table for the base units and
then one for the options or what would work the best.

I am working on my first database development project.

 

[Lord Kelvan]

ok here is what you table structure should be

tblproduct
productid
productname
basecost

tblorder
orderid
productid
optionid

tbloption
optionid
optionname
addoncost


if for some reason the base costs of the units or options will change
you need to add another table

tblinvoice
invoiceid
orderid
invoicecost

if you need to know the cost of each item indivitually you need to
change the structure a bit

tblorder
orderid
productid
optionid
optioncost

tblinvoice
invoiceid
orderid
basecost

hope this helps

Regards
Kelvan