AnsweredAssumed Answered

Question about creating a multi-field relationships and TOs

Question asked by MichaelKaufman on Jul 9, 2011
Latest reply on Jul 22, 2011 by MichaelKaufman

Title

Question about creating a multi-field relationships and TOs

Post

Lets say I have the following tables

Table 1:Cust

-------

CustID

Table 2:Orders

------

_fkCustUD

_pkOrderID

_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.

Thanks.

Outcomes