Returning value from related table

  • Thread starter Thread starter Mick
  • Start date Start date
M

Mick

Access 03
Have four entities. Customer, Order, Order Details and Product.

In an order form (based on Order as parent and OrderDetails as
SubForm) I want to return the price of an item stored in the products
table.

I have tried to build a query and use the value from the ProductID
field as the criteria and place the looked up PartPrice in the control
source of the ProductPrice field but get a #name error.

This works fine on a standalone form, don't understand why it won't
work on a subform.

Any help appreciated.

Thanks

Mick
 
Do not use criteria as you would need to refresh everytime you changed records.
Use a join in you query.
 
Back
Top