Ok so the purpose of this is to raise outgoing EDs for the company I'm working on the DB for
I have done it differently before but the issue is the rework can make it very difficult I made a union query to search for the data but it was not a recursive table structure which allowed for the use...
Ok so ill try and explain as best I can
What I am looking for is the associated EDNumbers and HarvestDocsNumbers from tblInventory (incoming goods) that are the source for a specific loadout
there are 3 tables involved
tblEDNumbers (these numbers are imported from via an external .xlsx file...
Hi All
I am currently working on a traceability Inventory DB with a recursive table for the inventory tblInventory which is joined to a many to many table tblTransactions
how can I use VBA to find all the incoming goods going into a specific outgoing product without knowing how many levels of...