Have you looked at using the "Export value" for the selection?
When an item is selected the value for the field is the "export value" and not the "item" value.
So it is possible to use the Export value for Drop box 1 but probably not Drop Box 2 because there could be the same price for 2 different items being purchased. So for drop box 2, one would need to look up the value in array.
Can you give me an example of how I would list the items in the export value and how I would script drop down 2 to read that list?
Thanks, gkaiseril for contribution, actually I have created 5 columns but there is one issue regarding amount type if you see my attachment for excel spreadsheet there is an option to auto convert any amount to another.
So there is any way to create something like excel sheet?
A PDF file with some auto calculations but not what I am looking FILE