Hi, Everyone,

I know i should not do this, anyway
I have put spaces in my field names to improve presentation when the fields are displayed, all seems to work however, when i use the filter routine
i have a field called "Last Name" and when i try and filter using its giving me the error


Error: No record found
SELECT COUNT(*) as c FROM imgbank WHERE ("Last Name" = 'Morris&#39

if i change the field name to "LastName"

the same filter works

Now i know i can change the field headings using templates, but that seems rather complicated and you have to use a template for each mode (display add, filter),

can you provide an example of using templates to replace field names or is there a way i can use the dbUserLocalText property to replace my fieldnames

which would you suggest