Records Not showing on a Form

[beerguy]

Guys,
Sorry for asking what is probably an easy question for you. I have records that are not showing up on one of my forms, and i have found the cause is that there is not a record for that primary key on another table. Simple example.

item 1400 is in the item maintenance table but not in the forecast, inventory update, or sales. So it does not show up on the form at all. I would prefer that it shows...

Any help would be appreciated

[beerguy]

Nailed it! Join types for the win....

[RuralGuy]

Those Inner Joins can get you every time. Thanks for posting back with your success and solution. Welcome to the site.