Reply to thread

Message: [QUOTE="The parawon, post: 2557892"] I am trying to return all the records from two different tables with an intermediate "join" connector line on a common field [part number] to both tables. I realize some of my records will repeat but I want to proceed anyway. Is there a way to return all the records from my first table and second table in a make-table query? My first table has [part number] records the second table doesn't have. My second table has many similar [part number] records as my first table but also has additional records the first table does not have. Any point in the right direction would be greatly appreciated. [/QUOTE]