Wildcards in linking field

[happydermis]

Hi all,____I would like to merge two tables with each other (Xbase). The problem _ the Table I would like to link doesn_t have the right index. One solution would be to create a flexLink but this is problematic because this table is about 800MB and it takes time to index it _ time I would like to save.____I would like to create a field, which will help my link both tables. The question is: is there a way to create a linking field in which some parts of it are wildcards?____Example: STR(manufacture-No.)+STD(_wildcard_)+STD(_wildcard_)____I can actually only use the manufacture-No. in order to link both tables but the index in the linked table dictates me a certain string the linking table doesn_t have. Is there a possible to use wildcards in a linking field?____Thanks, Dekers __

[kfleming]

You can set an relation as a partial match to only match the first X characters of the related file index.____So if you are linking on FIELDA and the index key is FIELDA+FIELDb+FIELDC____you can set a partial match. If FIELDA is 10 characters, then the partial match length would be 10.____Kathleen__R&R Support

[happydermis]

Thanks Kathleen,____I actually tried this once but the button "partial length" was grayed out for me. Only today I understood why - the field I was tring to index was numeric and the index was a STR() of this numeric field. After I created a calculated field and converted it to STR() I could use this button...____Thanks again, Dekers