Access HELP

[vertigo]

hello APer's, does anyone here know much about Microsoft Access, need some help with this, may seem preety basic to you but its driving me up a wall trying to solve it

basically i have two tables Service & Order, in the service table i have 3 fields where i have stored all the services that my database is suppose to hold, ServiceID(primary key), Service(what the services are) and Price (price of the services)

now in my second table Order is where the user makes orders for whatever and have 11 fields, one of the fields in the order table (ordertype) gets the services from the Service table, which is fine, but the other field in the order table is what is giving me the problem, this is the Price field.

What i am trying to do is, when the user selects an order type from the order table, i want the price of that order to display in the price field in the order table , it should look at what has been selected and display the price

[mindstate]

I know that in my CV it says I am proficient in it...

[vertigo]

well if you are, then i got lots more questions for you, but first help me with this one

[aLegend]

hold down alt and then press f4. it does it all for you.

[Evil_Genious]

There is no question in that wall of text. What's the problem? Looks straight forward one to many relationship (I'm assuming - because your Order table references one Service table entry).

[vertigo]

the question was how do i autopopulate the price field when the order type has been selected

but ive found a microsoft help on that issue which solves my questions

so thanks anyways