Recent content by LDD
-
L
Add multiple from one table to a single record on another table
I have two tables tbl_Orders Cust OrderNo OrdLne Prod Qty ABC SO123 1 AA 15 ABB SO124 1 AB 10 tbl_StockLoc Prod Loc Qty AA ZX12 10 AA ZZ12 10 AA ZZ13 50 AB CW12 15 One product can have up...