Ok, I had this working once but now I can't replicate it.....
I am comparing 2 tables, trying to find matches on a specific field then list the information from the second table. My issue is that each occurance returns data, not just the first occurance. I did a little research and found that I could use Unique Values on the join - so I set it to Yes. I think this worked once, now I'm not sure.....
Here's what I did
Table 1 joined to Table 2 on MR# (Not a key field in either table)
Join properties - Unique Values: Yes
Table 1:
64820 06/01/2014 356911765 06/02/2014
64820 09/20/2014 375921754 09/25/2014
64820 12/04/2014 385601865 12/15/2014
Table 2:
64820 3/14/2014 323401765 3/15/2014
My result:
64820 3/14/2014 323401765 3/15/2014
64820 3/14/2014 323401765 3/15/2014
64820 3/14/2014 323401765 3/15/2014
When I had this working there were 33 records returned, now there are 45. The extra 11 are from this lovely issue.
I'm sure this is pretty easy but for some reason I'm not seeing it. Any help is greatly appreciated.
Thanks!
Renee
I am comparing 2 tables, trying to find matches on a specific field then list the information from the second table. My issue is that each occurance returns data, not just the first occurance. I did a little research and found that I could use Unique Values on the join - so I set it to Yes. I think this worked once, now I'm not sure.....
Here's what I did
Table 1 joined to Table 2 on MR# (Not a key field in either table)
Join properties - Unique Values: Yes
Table 1:
64820 06/01/2014 356911765 06/02/2014
64820 09/20/2014 375921754 09/25/2014
64820 12/04/2014 385601865 12/15/2014
Table 2:
64820 3/14/2014 323401765 3/15/2014
My result:
64820 3/14/2014 323401765 3/15/2014
64820 3/14/2014 323401765 3/15/2014
64820 3/14/2014 323401765 3/15/2014
When I had this working there were 33 records returned, now there are 45. The extra 11 are from this lovely issue.
I'm sure this is pretty easy but for some reason I'm not seeing it. Any help is greatly appreciated.
Thanks!
Renee