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.