Search results

Sure thing. I've gone ahead and attached it in a Zip file. Basically, what happens is that someone imports the Overstock Report from an application we have, and imports it into tblOverstockReport. They then import the Bin Locations. Macros are set to run several queries, which "massage"...

I don't really want to go in-depth as to why there is a Table 3 (I agree with you guys), rest assured that it is necessary due to other manipulation that goes on and how the end user will be adding new data. I agree with you whole-heartedly, and the database is not designed how I would choose...

I attached the query. Overstock Kitting is Table 3. Bin Location is Table 2 and includes the dimensions. Please omit the "Table 1" I provide as a reference above, Table 3 includes the information needed. I tried linking both TargetPart and TargetJob from Overstock Kitting to their...

Well, the reason I have a 3rd table is because the data from the 3rd table gets run through a Macro which spits out the data into Excel. I'm "inheriting" this database and working around what's already been programmed and done. Cubic Volume and Weight are calculations based off of the part...

Alright, So I have two different tables, Table 1 that includes basic order information and Table 2 that includes dimentions for each part number. Unfortunately, there is no primary key that I am able to use for each record. In layman's terms, how can I create a Table 3 which combines the...