1 Reply Latest reply on Feb 22, 2012 8:21 AM by philmodjunk

    Value List Filter

    MarkJohnson1069

      Title

      Value List Filter

      Post

      I have 2 tables, voucher & payment where there can be many payment for 1 voucher. Both tables have client id and have set a relationship based on that field. If I include a portal display on the voucher layout showing related records from the payment table, it displays correctly, however it I create a value list using the same table, it show every record in the payment table (related and unrelated). What am I doing wrong?

       

        • 1. Re: Value List Filter
          philmodjunk

          Voucher::ClientID = Payment::ClientID

          Value lists that use the "use values from field" option will list values from the entire table unless you select the "Include only related values starting from:" option.

          In your case, if the above relationship is correct, you'd select "Voucher" as the "starting from" table.

          This is called a conditional value list.