Search results

I've done some Googling and search the forums but am drawing a blank or not understanding the proposed solutions correctly. Problem Statement: Find the last 6 records for each supplier/item combination from a list of 100's of records. Data: ORG VENDOR_NAME ITEM PO_NUM LINE_NUM LAST_UPDATE...

Don't you just hate that, 10 minutes after the brick wall I get the link I needed :D Thanks to Bob Larson's help on another post. My issue was not correctly selecting the container! Now I have I can work on adding some cascading combo boxes as an alternative and then adding the update SQL to...

I've reached that point where I can no longer think straight about a form issue, despite many searches :banghead: Here's what I am trying to do: I have a team working for me who are responsible for taking an action on multiple records once a certain stage has been reached. I've got all the...

jdraw, Thanks. That works just how I'd expect it to :) What I hadn't really got my head around is that I needed all the sub-inventories and locators mapped in that table before I looked at the migration of the inventory. I just need to expand the data set to all 30k lines of inventory and 400k...

I am having a brain block on how to approach a problem I have with Inventory. I need to be able to migrate an inventory snapshot built from 2 separate stock records which at their highest level (Item/Lot/Qty) will be the same. My first step is to create a 'matching' inventory table based on...