Relationship failure

[DalePearmain]

We are having a problem linking a table. The index key is Ref+Date+"" and we do a partial match on the reference. The following is displayed:____REFER . . NARR . . DATE__123 __123/1 . . More . . 01/04/2008__123/2 . . Text . . 05/05/2008____We created a test index with the key Ref+Date and the results this displays are correct, thus:____REFER . . NARR . . DATE__123 . . . Some . . 10/11/2008__123/1 . . More . . 01/04/2008__123/2 . . Text . . 05/05/2008____Why does R&R not find the matching record using the original index? What can be done to rectify?____We would prefer not to have to rewrite and redistribute an application and lots of reports if possible.

[kfleming]

Try varying the length of the partial match. Start with two characters and then keep adding one at a time to see if you can find the point of failure.____Kathleen__R&R Support

[DalePearmain]

It seems to be as soon as the "/" is included the relationship fails, i.e. in the original example a partial match of 4 characters.____Obviously using anything less than 4 gives the wrong information on the rest of the report.

[kfleming]

I will set up a test here and see if I can get mine to fail as well.____Kathleen__R&R Support