Calculation using second value in DropDown List (cost) * Quantity
Hey guys, I have two tables...
Date (Calender) / Case Number (Editbox) / Item (Dropdown) / Quantity (Editbox) / Total (Calculation)
Item (text) / Cost (currency)
On my Entry form, the Item dropdown is populated with values from the Items table, showing both values (Item/Cost), so that the user can select the item they want, and see the cost for that item as well. What I need to happen is have a Calculation in the Total editbox that multiplies the second value of the Item selection TIMES the number entered by the user in the Quantity editbox. Any help would be greatly appreciated?