www.hkvforums.com

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.

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.

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?

Thanks, mobhar.

It works.