price displayed as result of type and size

[Marotta]

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

[MnR]

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

[stanley]

This is a double-post, and Lee will get you in the morning.

-Stanley

[MnR]

Correction:

A triple poster, now thats against the rules!

[Marotta]

thank you for the reply sorry about the double post didn't quite know which area to post this query in.