Linked Table Without Related Data in 2nd Table 1

[GrandPaHiker]

I am trying to set up a report that will return any orders that has a contract number but does not have a production date. I have no problem getting the report to return the orders that have a 'Contract_Code'. However I can not figure out how to get it to include the orders that have 'Contract_Code' but are not listed in the Production_Tbl.

The tables are linked via 'ID' in Order_Tbl & 'Order_Tbl_ID' in the Production_Tbl.


Order_Tbl
ID Customer_Number Contract_Code
1 123 987654
2 262
3 183 887745
4 346 452398
5 756 745766
6 882 832145


Production_Tbl
Order_Tbl_ID Production_Date
3 081010
4 081210


Resulting report should look like:

ID Customer_Number Contract_Code
1 123 987654
5 756 745766
6 882 832145

I am new at this & appreciate any suggestions.

 

[Turkbear]

Hi,
If there is no record in Production_Tbl with the same ID as in the Order_Tbl, you cannot link by ID unless you use a Left-Outer join to insure that all Order_Tbl records are returned that match your selection criteria , which I assume is something like
IsNull({Production_Tbl.Production_Date})





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[GrandPaHiker]

Thanks for such a quick response!!