Drop down list QUESTION ?

[Mike G]

Can someone tell me if this is possible? I was tinkering with the Business Tracker db I downloaded and when I open a pending invoice and click on the product code a drop down list appears with a selection of products available to apply to the invoice. When I drop the list down again to add another item to the invoice the "previous" product is still available in the list.

Is there a way to change it so that once a product is applied to a particular invoice it would NO LONGER be available for selection again. I can't see a reason why you would want to apply the same item to ONE invoice more than once. It would make it easier if you could eliminate that item from the selection list while you were working in that one particular invoice.

Thanks

[RalphL]

I have done this using the Troi Text Plug-in. I make a list of all products and list of products used in invoice. Then I use XOR function on the 2 lists to produce a list of unused products.

http://www.troi.com

[Mike G]

Not familiar with that plug in yet but will check it out... thanks.

Sorry for posting this here by the way... didn't see the Business Tracker forum until a while ago....