I'm trying to make a simple dynamic table that allows a user to select a food item and quantity with a read-only field that shows the total price. I've added some items to a drop down box in the table, assigned values them after selecting "specify item values", and then created what I think is the appropriate FormCalc formula for the price field (Qty*HorsDeouvresItems). The price field is calculating correctly, but every time I click into the Qty field the displayed text in my drop down box (HorsDeouvreItems) changes from the item to the numeric value. Where prior to clicking the Qty field "Smokes Salmon Mousse" now reads "3.25"...... Am I missing something terribly simple? Thank you in advance to anyone reading this and any input is greatly appreciated.
Well, I'm not sure what I changed, and I don't actually even recall changing anything since I last tested it with the same result, but it's no longer exhibiting this behavior.
.clearItems script I was toying with earlier; in case anyone is racking their brain.