Update / Append Query

[bnickelsen]

I have 3 table

Table 1 is a list of parts.

IDParts (PKAutonumber)
PartNumber
PartName

Table 2 is a list of System the parts can be used in.

IDSystem (PKAutonumber)
SystemNameShort
SystemNameLong

Table 3 is a join table for the firts two


IDPartToSysJoin (PKAutonumber)
FKToPartList
FKToSystemList


Now I built A Query to Show the Parts by System but want to have the option to show "ALL".

I Thought about Making an "ALL" System But that seemed redundent.
Any Suggestions?