Hi

I am having real trouble with getting my head round how to structure the relationships between tables for the following.

Background: Need to implement a purchase order feature. I've created purchase orders, products and suppliers tables.

Requirement: The user selects a supplier on the purchase order layout. Then the user selects a product (not all suppliers supply the same products). So far so good, I have managed to implement this.

Now when the product is selected, I want the unit price (and other fields) to default to the price that supplies it. The user can type over if they wish, but at least the default price is there.

This I have not been able to work. At the moment, it gets the price from another supplier rather than the one selected for the purchase order.

Attached is the FM file. I hope I am not the first person who has this need, cause we'll be in trouble, as I have worked on this for 2 days solid now, and I may not have the brains to solve it!

Thanks in advance.

Orders.zip

I think the SupplierProductCode in POItems needs to pull in the SupplierCode from the PO, then you can add POItems::SupplierProductCode = SupplierPricing 2::SupplierCode to the relationship.