[RESOLVED] CR 11 Table Linking Issue

[Besoup]

Hey,
I have 2 tables one is called AgentFees and the other is called Agent. In my report I am displaying AgentFees records according to a date that I pass as a parameter. I need only 1 field out of my Agent table which is the agent name I get that by linking the AgentFees' Agent_Number field with the Agent's Agent_Number field. The problem is the AgentFees' table has some ficticious Agent_Numbers that won't match in the Agent table, when linked it reduces the number of records shown on the report. Does anyone know how I can still show the records that don't have a match in the field or a different way I can retrieve the agent name without linking the database fields?

Thanks for any input.

[brucevde]

You need to link the tables using a Left Join instead of the default Equal Join (Inner Join). If you are using the Visual Linking Expert (I don't have CR 11 and am assuming it is still there), right click on the line that links the two tables and choose the Options menu item. Set the Join properties in the dialog that is shown.

[Besoup]

Thanks again Bruce!