Hi all, thanks for the time to answer my question.
I am designing a new report that will allow customer service to easily list and fill out the contents of our various size packaging boxes and cartons.
In our back-end database, we have a table for our finished goods, and then a separate table for all individual parts (we have chosen to keep these tables separate since we have an application that allows users to look up multiple and shared parts for each finished good via a Linker table).
However, both tables have an "Item Number" field which needs to be accessed on this new report. For example, in a typical order we may have a finished good with an item number of 5 but also additional parts ordered of item numbers 11, 12, and 13 that all will be shipped in another carton.
Obviously, this presents a problem, as throwing in both tables will make Access require that any given item number will be found in both the finished good and parts tables, which is not what I'm looking for. Rather, I'd like it to look in either table and upon a match give me information about that particular Item Number.
Any suggestions? Thanks in advance!