Hi

I have imported some old fm3-databases into fm5, most things work by now but references based on relationships don't. the usually consist of an entry-field on first database which is compared to a formula-field on the second (formula works correct, i tested).

While does worked in Fm2, i dont know why not in fm5. would it be a different index- approach?

some references work partly, i.e. if i put in the surname only it's ok, but if I write "Surname, Name" (delimited by comma like it worked in FM2) it doesn't work anymore

would really appreciate help, tried so much for nothing ....

The default indexing is English and will ignore punctuation. Try setting your indexing to ASCII. Also make sure that no single "word", as delimited by spaces, is more than 20 characters,

back from holiday..and still facing same problem.

indeed, some indexes exceed the 60 letters so will have to change the logic behind database.

but some indexes are within your mentionned range, so there must be another problem as well - for which I would greatly appreciate advice....otherwise i will need some holiday again within a few frustrating days...

phil