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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vshvidky

    Displaying lines based on a variable

    OK, I edited OP to make it easier to understand. Hopefully, it makes more sense now. So my STOCK.QTY of ABC in bin DMG is 5. I need to show only the latest transactions that will match the qty of stock. So while there are 5 records in the STOCKTRANSACTIONS for ABC, I need it stop printing...
  2. vshvidky

    Displaying lines based on a variable

    Sorry, made it confusing with transaction numbers, trying to simplify the issue. TXN 5 is for a different product(DFE), so OH QTY for DFE is 1. And adding other transactions for ABC, you get OH QTY = 5. Each transaction just shows the adjustment for the product at that transaction, not how...
  3. vshvidky

    Displaying lines based on a variable

    Hi there, I have 2 tables: STOCK table and STOCKTRANSACTIONS table. The stock table shows me how much product I have in every bin right now. STOCKTRANSACTIONS have every product transaction recorded (could be in multiple bins). I am trying to display all the latest transactions that apply to a...

Part and Inventory Search

Back
Top