Combo Filter Issue

skymark · Post by **skymark** » Thu Oct 10, 2013 10:38 pm

Hi all,

I have an orderdetail table that has a field called inventoryID. I use a view called availableInventory as a lookup table. The availableInventory has a clause "where QtyOnHand > 0". When the users go to add/edit pages, they can see available inventory items only. QtyOnHand is dynamic, i.e. it would be changed to 0 after being ordered. But on the list page, the orderdetail records with inventory items that have QtyOnHand = 0 show inventoryID instead of the inventory names. Is there a way to fix it?

BTW, I can't use the filter on the "Lookup Table" tab on phpMaker b/c "Allow sort/search" won't work if I do so.

danielc · Post by **danielc** » Fri Oct 11, 2013 10:31 am

inventoryID cannot lookup a name in availableInventory's lookup table so it will display its original value. If you want to have replace name whatever the QtyOnHand = 0, you need to use your lookup table without filter.

skymark wrote:
BTW, I can't use the filter on the "Lookup Table" tab on phpMaker b/c "Allow sort/search"
won't work if I do so.

This is the limitation mentioned in help file.

mobhar · Post by **mobhar** » Fri Oct 11, 2013 10:43 am

In v10, there is a new server event called with "Lookup_Selecting". Fired before selecting records from the lookup table. For customizing lookup table filter dynamically. Have you tried it?

skymark · Post by **skymark** » Sat Oct 12, 2013 9:14 am

Thanks, mobhar.

It works.