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
Bookmarks