Search results

Hi spikepl, Thank you. Yes, I definitely need to structure the Keys/Numbers better. Does that mean in your example that I need to add to the PO table you listed as well the Supplier_ID in order to know to which supplier under an Order the PO belongs to? Cheers, Steve

Thank you very much spikepl That makes sense. If I continue with your Order/PO example: How do I automatically create this Purchase Order Table? I assume if I do it your way it's not possible to have a Purchase Order ID like "OrderID-1", "OrderID-2", "OrderID-3", ... consecutive for the...

Thank you very much Beetle The data is not sorted and your query is what I need to create one SubID per ReqCat. I assume I can append your query to a table as I still need Table3 to track a few things separate from Table1 & 2. And I need to make sure that once a SubID is assigned to a record...

Hello, I am struggling to find a code to automate the following simplified situation. I am able to understand VBA examples but not really capable to create something that works myself :-( I have Table1 that will be loaded daily with new data and then combined with Table2 for the ReqCat column...