This should only be a quick one, but has had me stumped for a while.
Am creating a DB for Mrs S so she can keep track of her orders in work. There is a drop down list containing prices for items and am trying to get it so that when she selscts the price, a field is automatically populated with the order cost (price*no of units).
So far, have got the maths side to work, but it appears that instead of the price that is selected being transfered, it is the price ID (eg the 12th on the list is £2500, this returns £24 not £5000)
Anyone got any ideas???
Thanks in advance
Paul
Am creating a DB for Mrs S so she can keep track of her orders in work. There is a drop down list containing prices for items and am trying to get it so that when she selscts the price, a field is automatically populated with the order cost (price*no of units).
So far, have got the maths side to work, but it appears that instead of the price that is selected being transfered, it is the price ID (eg the 12th on the list is £2500, this returns £24 not £5000)
Anyone got any ideas???
Thanks in advance
Paul