Query designer question
Posted on 2013-01-17
I'm trying to figure out how to create a select query that will pull records from two different tables if they have a common field name.
tblOpenOrders and tblFinGoods
both have a field named "PartN" and I want the query to return all the records from tblOpenOrders AND ALSO all the records from tblFinGoods using form criteria like:
So if tblOpenOrders has 5 records equal to "Forms!frmCloseOrder!txtPartN" and tblFinGoods has 10 records equal to "Forms!frmCloseOrder!txtPartN" I want 15 records to display when I run the query.