Just a thought for something that might be useful.  Could we have a simulated picklist program?  It would be great that instead of creating work orders and deleting them - if we could enter a part, enter the quantity, and have the picklist come up with shortage amounts.

Hi Lorne,
 
Actually, I think I could build that in MS Access too, but I was looking for a quick, live, utility in DBA.  
 
Thanks anyways,
 
Mike

Yes it would actually

For a simple single level BOM it works ok.  For a multi-level, if there are sufficient subassemblies on hand, it still generates a shortage list of the components of the subassemblies as if they needed to be built.  It also indicates shortages of Phantom assemblies rather than bypassing them and looking at their components.  And as I recall when I was working on the programming specs to fix it, there were other issues as well regarding how to treat other allocations and future demand against components as contributing to the potential shortage.