Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Is this possbile? Allocating batch quantity to customer orders
Firstly, thanks for your response. The stock production date identifies the oldest batch. In other words, the oldest batch will have the earliest expiry date. So, i want to always use the earliest batch date first. yes - I will like to record the transaction and which batch or part batch was...- vomo
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Is this possbile? Allocating batch quantity to customer orders
I require someone's help please!!! I want to allocate always the oldest stock quantity of production batches to customer orders E.g. Let's say I have stock 3 of pens (from 3 different production batches) Warehouse Stock: Pen Stock1 = 20 (oldest stock), Pen Stock2 = 10, Pen Stock3 = 30...- vomo
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
-
add new record to query containing lookup data
I hope someone can help me. Please see below. EMP Table LOC Table ID EMPID EMP LOCID LOCATION 1 1 SALES REP1 1 LOC1 2 1 SALES REP1 2 LOC2 3 1 SALES REP1 3 LOC3 4 2 SALES REP2 4 LOC4 5 2 SALES REP2 5 LOC5 The EMP and LOC tables were joined to give Query1, whereby LOC.EMP is selected...- vomo
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
