AnsweredAssumed Answered

Need help tweaking Invoices Starter Solution

Question asked by JoeMan on Aug 25, 2012
Latest reply on Aug 26, 2012 by JoeMan


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.