Thanks Mark, I'll look at the Left Join syntax.

Here are abbreviated table structures:


Parts
cPartNo C(9) -- Candidate Key
cPartDesc C(30)
nPartKey I -- Surrogate Primary Key


Components
cComponentNo C(9) -- Candidate Key
cComponentDesc C(30)
nComponenKey I -- Surrogate Primary Key

PartToComponent
nPartNo I -- FK to Parts
nComponentNo I -- FK to Components
PtCKey I -- Surrogate Primary Key

Category
cDesc C(30) -- Candidate
nPartNo I -- FK to Parts
nCatKey I -- Surrogate Primary Key

Ratings
nCategory I -- FK to Category
nPartNo I -- FK to Parts
nComponent I -- FK to Components
nRating N(5,2)
nRatingKey I -- Surrogate Primary key


What the users want to do is use the Category as the primary cursor. All navigation buttons\toolbars manipulate that data and components\ratings\parts change as you walk though. If a new category is desired, I am looking to display the components for the part with ratings as zero. (Note, the part is automatically set to the first entry in a drop down combobox upon new and is selectable. In edit mode the part is not selectable).

I can all this in two SQl statements but I would like to do it all in one SQL. Is it possible?