2 Replies Latest reply on Aug 26, 2012 12:53 PM by JoeMan

    Need help tweaking Invoices Starter Solution



      Need help tweaking Invoices Starter Solution


      Problem regarding Invoices Starter Solution:

      I am going to have well over 3,000 records in the Products table. The Invoice Data::Item field (drop-down list at the moment) will be inefficient for entering Items.

      One possible solution would be:

      Add the Category field to the Invoice Detail layout and have it filter the field I place next to it, Items in this case, to drop-down only items within that Category. This solution would bring the original list down to 100 at most -- much more manageable.

      The Value Lists do not allow this 'lookup value' feature or a calculation.

      Any ideas? I have FMP 12 Advanced.