Hi everyone.
I'm new in Access and I have to make only one project. I have a little problem with my access forms. I have few tables: customers,products, orders and OrdersDetails. I made form to adding orders. I have field where I can choose Customer and subform where I can add ordered products. I have there combobox where i choose given product, field for product price and field for quantity. So the problem is following: When i choose product, I want the price field will be filled with value from Product table (appropiate for chosen product).
Can somebody help me with this? I will be very appreciate.
P.S. Sorry for my bad English, I hope you'll understand what I mean.