field names with special characters.

[RickBman]

I hope this is the right section for this question, it seemed like the most fitting place.

Quite awhile ago I inherited a database that was written by another developer. The database is currently using Filemaker 6.

The problem I am having is that this developer liked to use different types of special characters to mark different types of fields, and now they are causing problem when trying to make a web solution out of the database. The special character in question is "ƒ" which she used to designate calculation fields (that is some fancy looking "f" just in case the special character doesn't show up on here). She also used "£" to designate lookup fields, but that one doesn’t seem to be causing a problem.

So, if I go in and rename these fields to remove the special characters how much of a problem is that going to cause in my database? Are all relationships and things like that going to remain in tact, or is everything just going to fall apart?

Thanks for the help,

Rick

Edited July 21, 2006 by Guest

[Inky Phil]

External files that reference any fields that you change are going to be a problem

Phil

[RickBman]

Yeah... I kind of guessed that would be the answer I would get...

Well I guess I can just create new calculation fields that point to those fields, and use the new calcs to display on the web. Of course then I'll have to go into each layout and make sure that the new fields are displayed on the layouts.