Conditional Value Lists
Using FMP 8. I have an existing DB. When creating an invoice, the customer info is pulled from the customer table. Over the years, this table has grown and now I need to limit the choices to just active customers when creating an invoice. I am doing this successfully using conditional value list. However, the customer names on old invoices for currently inactive accounts (not in the value list) are now displayed as the primary key Customer ID rather than the customer name. How do I limit the input options to active customers without affecting old invoices?