I know some of you guys love this sort of thing!

Basically I want to create a field which will look at another field - Accommodation Rating - and look up the weekly rate for any of the 5 values in Accommodation Rating. 

Do I have to store the weekly rates in a different field somewhere else? I took a look at Lookup fields, but they only work if the information is in a different module altogether?

Please let me know if anyone has any advice

Thanks!