Filtering Value List
In the Accounts payable portion of the system in question, there are a few tables:
- AP_Invoice (stores invoices from vendors)
- AP_Payments (stores payment records made to invoices
- AP_PaymentItems (stores the items to be made on a payment (similar to LineItems on an invoice)
On the AP_Payments records, there is a portal showing records from AP_PaymentItems. The relationship allows teh creation of new records in the AP_PaymentItems table. A pop-up menu based on a value list is available in the portal row for the user to select an invoice to include on the payment record.
The goal is to have the portal show only record from AP_Invoice when / AP_Invoice::cAmountDue>"0" /.
I have attempted to filter the records in the value list by creating a second relationship between AP_Invoice and AP_PaymentItems:
AP_Invoice::RecordID = AP_PaymentItems::RecordID and AP_Invoice::cAmountDue = AP_PaymentItems::Zero
where AP_PaymentItems::Zero is a number field with an auto-enter value of "0"
I get an index missing error. Any ideas?