Value List Filter
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?
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.