Liveware Publishing Support Forum

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.

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

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.

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