2 Replies Latest reply on Jul 22, 2011 7:44 AM by MichaelKaufman

    Question about creating a multi-field relationships and TOs

    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.