multiple items have multiple choices

[Adam1970]

Hi


I am new to using Access 2016 and am attempting to set up a quoting system. sorry for the long question

i have a list of products which have many different criteria
a customer may want a table manufacturing from mahogany (i have created the code for this) next he may want it a rectangle, circle or special design. if it is a rectangle i need a length & width. If its a circle i need a OD. if its a special design i would need length & width & possible od id.

the question is how do i link them all in a query. to create the quotation report

I can pull in description from my product data base but if he requires a rectangle how can i pull that field into the query and allow me to enter the length & width for the area calculation, or of he wants a circle how can i pull just one field into the query?

I have looked into all the youtube videos but cant find one that helps

Many Thanks
Adam

[June7]

You need a table that saves these choices for each design order/quote.

Could have a field for every possible design element but that could get unwieldy. Alternative is Entity/Attribute/Value model. A very rough example:

OrderQuoteID	Part	Spec	Val
1	Table top	Width	6
1	Table top	Length	3
1	Table top	Thickness	1
1	Table leg	Length	3

Manufacturing/Assembly style database is one of the most difficult to design. It is a common topic.