February 2, 200521 yr Is any-one able to help me i am currently making a database for a restraunt and I am trying to get a price to display when I select a type of drink followed by a size both these values should correspond to give the price any help on this matter would be greatly appreciated
February 2, 200521 yr Hi, I think a calculated field would do best here rather than a script, It would help if you could say if the size and type where times or added together but, the calculation would look like: DrinkType * DrinkSize But you should have the price field as a calculation and enter that depending on your structure. But with limited information all i can do is make a stab in the right direction
February 2, 200521 yr Author thank you for the reply sorry about the double post didn't quite know which area to post this query in.
Create an account or sign in to comment