Greetings all,
As the title indicates, I'm trying to create a query, and eventually a report, that will pull information from multiple tables in my DB. However, the tables do NOT have a relation.
For instance, let's say I have 4 tables, each consisting of separate information.
Each table has the following info: Description, Qty, Serial Number, Part Number
The tables are NOT l inked or in a relation in any sort of way. They all consist of similar fields but are basically inventory lists of different types of parts. So Table1 will have listings for parts for Item Type A, Table2 parts for Item Type B, etc. etc.
I'm having difficulty getting the query to 'probe' the information correctly. It will sometimes give me a few lines of correct data, and other times I either get a few blank lines, or mixed information (Table1's serial number in Table2's listing)
Is there a way to do this without creating relations? The way that the tables are setup is very simplistic. Each table is setup for a specific type of equipment (inventory management) so using refIDs won't work because each table has its own IDs.