Idaho

Thank you again. That helps.

Bingo! Extra trailing spaces are the problem. My source data comes from a variety of banks, and it is their technical terms that the use repeatedly that I am translating into common terms. Thanks for putting me on the right track. I would have never thought of it. Do you have any ideas how to set FMPro to strip out those trailing spaces? Otherwise I must spend time manually doing it.

Bingo! Extra trailing spaces are the problem. My source data comes from a variety of banks, and it is their technical terms that the use repeatedly that I am translating into common terms. Do you have any ideas how to set FMPro to strip out those trailing spaces? Otherwise I must spend time manually doing it.

Thanks for your help. Well, DUUUHHHH! I should have known I could use the cn field from the Translation Table in the Main Table, thus eliminating the need for a calculation field. Unfortunately, that didn't solve the problem. Still about 50% of the common names do not appear on the Main Table even though they are all on the Translation Table. I was successful in 2 times out of 7 of getting the common name to appear by deleting and retyping the technical name, then pressing TAB in the Main table. But that didn't work on the other 5 times, and neither did cut and paste. I downloaded the 7.02 update but that didn't help my problem. Attached are two screenshots of my tables. Any suggestions you can offer are appreciated. Samples .zip

I have two tables in my database. Both have two fields: technical name (tn) and common name (cn). The "lookup" table has only these two fields and is used to populate the common name in the main field. The link is with tn fields. The "main" table conists of the tn text field and the cn calculated field defined as: if(tn=translator::tn; Translator::cn; "?") The results are to print as text The calculation copies successfully about 50% of the time, tho when it does, it always displays "?". Thinking it was typo problems, I cut and pasted from one the technical field from one table to the other so I know they are identical. There is no appearant commonality between the data that don't copy successfully. I have tried testing this with the simplest possible database with only 2 fields in both tables. It too, was inconsistant. I am running v7.01a with Windows 2K and SP4. Anyone have any ideas? Thanks