hello, this is not really a programming questions but was not sure which other section to put this under but here goes
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
many thanks
Social Networking Bookmarks