Question about creating a multi-field relationships and TOs
Lets say I have the following tables
_OrderStatus (Open=1, Closed=2)
I want to create a portal showing all orders for a customer, so I create a relationship between the two tables. Very simple.
Lets say I want to change the portal to only show the open orders. One way I could do it would be to add a field to Cust called OpenVal which always contains the value "1" and create a TO of Cust which relate the Cust and OpenVal fields to the Orders table. Then I need to create a new form with a new protal on it.
Is there another, simpler way to do it? Ideally I would just like to have a checkbox on the form the turns on and off a filter.