Dropdown 1 has the list items: Fruit, Grains, Meat. The user selects one of these. If fruit is selected Dropdown 2 is populated with: apples, pears, bananas; if Grains is selected dropdown 2 is populated with: whole grain, rice, quinoa. etc. The other box is just a text field labeled price. So that when apples is selected it inputs a price for apples of $1.00 if bananas are selected it inputs a value of 3.00. I link to an example by Thom Parker can be found here: http://www.windjack.com/PDFSamples/ListPrograming_Part1_AcroForm.pdf, but don't need multiple lines or any sort of calculation. Hope this makes sense.
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?