Newbie to Access, help!

[jGURU]

Hi

I've been working with MySQL and i can assure you, it is considerably easier working with Access although the simplest things sometimes can't be acheived.

Basically, i am working on a college project in Access. I am trying to get the value in a table to change automatically in relation to its parent ID.

EG:

If ID=1 then Price automatically changes to £3.00, ID=2 then Price automatically changes to £5.00 and so on. All i get so far is a drop down menu which allows me to choose those values. I did this using lookup. Could this be wrong?

Any help on this would be greatly appreicated.

 

[Mile-O]

You should be using a query to calculate values and not a table.