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.