Joins to display data

[wilekoyote76]

I'm trying to figure out how to display the data that I need from 2 tables.
Below is what I have for criteria including the joins. Ref is not showing up on the report.

Table Names:
Contact1
ContHist

Links for Database Tables: (Under Database Expert)
Contact1.LastDate -> Conthist.lastdate
Full Outer Join
Not Enforced
=

Contact1.recid -> Conthist.recid
Full Outer Join
Not Enforced
=

Selection Criteria:
{CONTACT1.LASTUSER}='Brian' and {CONTACT1.LASTDATE}=today

Fields in the Report I'm trying to show:
Contact1.company
Contact1.contact
Contact1.lastdate
Contact1.lasttime
Conthist.ref

With the current information, the Ref field is blank and all other fields are populated.

I need it to populate all the fields...what am I doing wrong? Convert Database Null Values to Default is checked as well.

 

[Turkbear]

Hi,
Have you determined that that a Conthist.ref exists that matches your selection criteria?





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

 

[wilekoyote76]

Yes, conthist.ref does have data that matches the criteria. I have created a different report with each table only and have pulled the data by itself, but I want to combine the 2 tables into the one new report.

 

[lbass]

What happens if you comment out the date criteria in the selection formula? It might be affecting the joins.

-LB

 

[wilekoyote76]

I was able to find out the problem. By browsing through the data, I noticed that recid was not the same for all records. By name it is, but by key, it was a randomly generated number/character combination that had most of the same the info, but 8 bits were off. Given that it is not a primary key, I removed the link and linked other fields up appropriately that matched content