Back | Forward

A report lists parts stocked at a particular location, and shows the keyword and short description for each part. This report obtains the list of parts from one table and the keyword and short description for each part from another table; the two tables must be joined on part number.

Solution:

Select the Part Location table (PLO_MAIN) and the Parts table (PTS_MAIN). The Part Location table contains stocking information for parts at each location; the Parts table contains general and descriptive information that applies to parts regardless of their location.

Connections required:

FROM the Part Location table TO the Parts table, through the Part ID and Part suffix fields.

Required restriction:

PTS_MAIN.PART_part_no = PLO_MAIN.PART_part_no

AND PTS_MAIN.part_suffix = PLO_MAIN.part_suffix