Creating Portal That Filters Records
I am building a database that is made up of two databases, purchase orders and payments. Customers place orders and then make partial payments against those purchase orders. I have created a third database called accounts which shows a portal containing purchase orders and their current blance.
Since I am using FileMaker 11 I can use the filter control in the portal to I am able to create a relationship that allows me show all of the purchase orders and their current balances in a porta. However, I want to create a portal that only displays purchase orders that still have a balance, i.e., greater than zero.
I know this simple but am struggling nontheless.