When making a multi-table query in Microsoft Office, there must be an assurance that the tables are properly determined in the "Relationships Window." After which, the Microsoft Office's Query Wizard would greatly come in handy in constructing the multi-table query you want to create.
