Filter contents of drop down

[Gismo12]

Hi all,

lets say i have a invoice table and customer table

i want to select the customer from a drop down list but I only want to see active customers in the drop down.

How do I filter the drop down list?

[rwoods]

Hi Gismo

To do this you could create a relationship from the invoice table to the customer table that is only true if the customer is active. I don't know how you show a customer to be 'active' but a relationship from a field in invoices that is always say 'Active' to a field in customers that says 'Active' would do it. Use an auto-enter calc in the invoice table to set that constant value to always be 'Active'. Don't forget to force that value in for all existing invoices.

Then base a value list in invoices on that relationship, and you will only see active customers.