This is confusing. Your second sentence suggests that your Notes document contains just one value item:
My Notes document contains the language and either the value in language 1, either the value in language 2.
But your third sentence says the document contains two language values:
Is there a way to avoid the transfer of both languages in the notes document...
I think your thrird sentence is closer to what you meant to say.
So I think you meant to say:
1. That there are two values in the Notes doc, only one of which should be transferred
2. That there is another field, not to be transferred, which tells which language the value (that is, the value you do want transferred) is in
In other words your current setup looks something like this (note that the values you care about are highlighted):
Notes
| Key | LanguageKey | Language1 | Language2 |
| ADFE034523 | "2" | "blahblah" | "bonjour" |
| ACED290278 | "1" | "hello" | "humptdumpty" |
Oracle
| Key | Language1 | Language2 |
| ADFE034523 | "blahblah" | "bonjour" |
| ACED290278 | "hello" | "humptdumpty" |
Is that right so far?
Return to top
. . RE: Formula to execute before inser... (Thomas Kennedy 7.Jan.11) 
Print this page
