AnsweredAssumed Answered

Calculation using second value in DropDown List (cost) * Quantity

Question asked by ChrisNixon on Aug 2, 2013
Latest reply on Aug 2, 2013 by philmodjunk

Title

Calculation using second value in DropDown List (cost) * Quantity

Post

     Hey guys, I have two tables...

     Entry

     =============================================

     Date (Calender) / Case Number (Editbox) / Item (Dropdown) / Quantity (Editbox) / Total (Calculation)

      

     Items

     =============================================

     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?

      

     Thanks!

Outcomes