Thank you, here is what I did:
I used the functions from:
http://www.briandunning.com/filemaker-custom-functions/list.php
ExplodedKey(text) =
if(Length(text)>1;
ExplodedKey(
Left(text; Length(text)-1)
)& ¶ & text;
text
)
ExplodedString(text) =
ExplodedKey(text) & ¶ &
if( WordCount(text) <> 1;
ExplodedString(RightWords(text;WordCount(text)-1));
""
)
I then changed the calculation to:
NameRelate = 1 & ¶ & ExplodedString(Title)
Now a given search for a word like 'Book' will find all the relevant titles containing this word.
A little simpler but also makes the Indexes a little slower to update and the file bigger! So be aware!
After the update is made, will it have any other consequences besides the extrastorage for the long title names being exploded?!?
Will it effect the find relationship time for many titles?
Find other similar functions here:
http://www.briandunning.com/filemaker-custom-functions/list.php