I am working in Filemaker 9.
I have a contact database file where I auto-format the first and last name fields with the following auto-entry calculation:
TextFormatRemove(Proper( Substitute(TrimAll ( Self ; 1; 2 );¶;"")))
The do not replace existing value checkbox is not checked
It works fine when I am working within the file.
However, I used the contact table from this file in another fm database, and when entering information from that file the autoformat does not work.
Do auto-enter options not trigger when entering data through another file in filemaker 9?
Any help would be much appreciated,