Hi
I'm having the following problem:
Tables:
Warehouses (warehousId, warehouseDescription)
Item (itemId, itemDescription, itemPrice)
Warehouse (warehousId, itemId, stock)
Order (orderId, date, warehousId)
orderDetail (orderDetailId, orderId, itemId, quantity, unitPrice)
I created a database view:
Item.itemId, Item.itemDescription, Item.itemPrice, Warehouse.warehousId, Warehouse.itemId, Warehouse.stock
I use this view for the lookup on add/edit in orderDetail
I need a filter to display only items from the warehouse selected on the parent page "order" with stock > 0
How can I do it?
Thanks in advance,
Nir.