If I have a parent where the field used to restrict a child browse contains an apostrophe then the child browse displays no records. It has nothing to do with unique field identifier just a specuial
For example in the 3 filters below filter 3 doesn't work because of the apostrophe, obviously because the filter value becomes
'BS3357 ST BENEDICT'
[2816] [st] [netTalk][thread=3] filter:FOL:Reference = 'BS3358 ST JOSEPHS SCHOOL - FOURIESBURG'
[2816] [st] [netTalk][thread=3] filter:FOL:Reference = 'BC3051 CRAVEN JAMES ROOS'
[2816] [st] [netTalk][thread=3] filter:FOL:Reference = 'BS3357 ST BENEDICT'S SCHOOL - LADYBRAND'
Is there any way short of telling the client to pull out any apostrophe from his field that I can get around this issue