Auto-fill unit price in tblOrderDetails from tblProducts

[Hey Lucy]

This is a Customer Orders database created in Access 2010.

tblProducts has field UnitPrice.

I want the unit price to auto-fill based on product in tblOrderDetails.

Seems simple enough, but I can't figure it out. I don't know VB other than inserting code someone else has created. Need to be able to do within Access.

I've researched this and found many databases of this sort that has the Unit Price in the Products table but you still have to input the Unit Price when adding an order. This just does not make sense to me. If you have to manually enter the Unit Price on an order, what is the point in having it in the Products table?

Anybody know how to do this?

Thanks for help and suggestions!

 

[pr2-eugin]

How about AutoFill?

 

[Hey Lucy]

Thanks pr2. I am trying to figure out auto-fill as I have never used that option before. Could you explain auto-fill to me? I have tried doing it using the tblProduct and the tblOrder details in a query, but I'm confused about my relationships.

When I create the query then create a form based on it, it shows current order details and the prices but doesn't allow me to add anything to it. The add new record selector is grayed out.

Thanks for your help!