Form Field value updates

[l2extasy]

Hello guys! This is my first post here and i'm in desperate need of assistance. I need to finish this database for my bachelor's degree, but i'm kind of slopy with Access, i'm more the database modelling only kind of guys.
Anyway, i have these tables Clients, Orders, OrderDetails, OrdersConfirmed, OrdersConfirmedDetails Products (not going to include Sales Agent), and my issues are:
1) how can i update the Price field in my OrderDetails, with the Price (standard listing price) already entered in the Products table?
2) also, how can i select which fields are going to update my OrdersConfirmedDetails table by using data already stored in the Orders/OrderDetails tables ?



Not sure if i made myself understood, but i can explain further if needed. Great thanks to any incoming help, have a nice day!

[Robeen]

If you are talking about entering order details in a Form -> that is bound to your Order Details table -> what you could do is:
In the 'On Change' Event of the Product ID field in the Form - put in some code that takes the Product ID from the Form and finds the Price for the matching Product ID in the Products table.

OR . . .

This page has a pretty good explanation / example of using the 'DLookup' function for what you are trying to do.
http://office.microsoft.com/en-us/ac...001228825.aspx

Let us know if you have any other questions.
All the best!

[l2extasy]

I've read your post and i think this might just do the trick and if so, you're a life saver, thank you very much. I'll try this as soon as i can and reply with the results. Have a fine day!