Califdon.
I have gone back to using a BOOLEAN SEARCH as this provides the ability to conduct a FULL TEXT search without the need for a FULLTEXT index. As I said before, it's not just the URN (primary key) I need to search. Each individual's record contains the URN of their mother, father, siblings, spouses and children and I need these searched as well.
It's a work in progress. Shame I'm not making much progress!!
KD.
Checking my database
Moderator: General Moderators