AnsweredAssumed Answered

Conditional Value Lists

Question asked by sourkraut on Dec 5, 2009
Latest reply on Dec 7, 2009 by comment_1

Title

Conditional Value Lists

Post

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?

Outcomes