Customer price list
New to FileMaker and creating databases. Have looked at most of training material but still not 100% sure how to proceed. My database consists of three tables:
- Prices by customer for the same product. Each customer has a different price for the same product.
I would like to be able to input a customer name in the main part of the form which triggers in the portal the products ordered by that customer and the unique prices those customers pay.
Can someone explain to me the best way to do this please.