Problem - Report returns same Contact History for all contacts with same name

[chad]

Part of a report that I put together in the basic report editor includes a subreport to return Contact History date, result and details.  If I have two contacts with the same name, it always returns the contact history of the same single contact (ie Contact #1, #2 and #3 all report Contact #1's history).  The fields in the [main] report still work properly, being specific for each contact.

I did a database maintenance procedure (check, repair, rebuilt everything, reindex) but it did not fix the problem.  Does anyone have any suggestions?

Thanks 

[Roy_Laudenslager · Accepted solution]

That's your problem, use Contact ID.

[Roy_Laudenslager]

What is your linking field for the subreport?

[chad]

I'm using Contact to link to the subreport.

[Roy_Laudenslager · Accepted solution]

That's your problem, use Contact ID.

[chad]

Ah, works like a charm.  Thanks Roy.