Linking help needed

[crystalfun]

I have two tables. Table 1: all employee data including termination date. Table 2: Termination table which includes termination reason.

I need to write a report that includes term. date and reason in one of the headers. If the employee is still active I still want the employee report to run but not show term date and reason. I know have to use both tables and link using employee ID and understand how to suppress if they are active.

The problem I'm having is that when I run reports for each employee only the ones who have been terminated print. If the employee is active their date won't print. Is there some sort of special linking, joining, or something else I need to do to get the report to print for an employee weather they are terminated or active?

 

[dcm]

crystalfun: You are almost certainly using the default equal join type relationship between your 2 tables. The net result is that only employees with an entry in the termination table are listed. To include all employees whether or not they have an entry in the termination table you should change the join type to Left Outer Join. You don't mention what type of connection you are using (Datafile or SQL/ODBC) but if you are using Datafile you may have to change to SQL/ODBC to reveal this option when you click on a join between the 2 tables and select Options David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner