Hi guys,
I am working on a database for stock movements, and need the following to happen:
On the TransactionHistory table, when a StockItem has been picked, the Warehouse list needs to filter based on the StockItem.
The following is the setup for my dBase:
StockItem
Warehouse
WarehouseItem...