Hi there,
I'm having a problem with the return a query gives me when it is run. This query is set to list select parts by Manufacturer name and our part number; followed by the part description and the manufacturer's part number.
Here are the results:
There are blanks where company names should be and there are a few repeats missing (same part number, different manufacturers).
This query is run off of three tables. Here's the set up:
I've checked and rechecked the three tables for errors.
For example, in the Component Status - Active table, there are the appropriate 3 entries for the part number QS10004; the Component Description table is accurate and the Supplier Information is also accurate. The New ABBR in the SI Table is the same abbreviation that is listed in the MFG field in the CSA table.
So my questions are:
1. Why are the multiples not showing up (again; same part number, different manufacturers), and,
2. Why are the company names missing when they are listed (joined) by the same abbreviations?