Auto enter a field with another record entry on the same table

[paifu]

Hi, i just started a database for a Lao/French/English Dictionary.

Lao words are often composed juxtaposing some base words. For exemple the word BLUE (si:fa:) is composed with the word COLOR (si:) plus the word SKY (fa:).

So with my main word table I have all this words on seperate records and I want to have a field "litteral translation" going to search in the others records the translations of the base words of my composed word.

I created 3 fields lao1 lao2 lao3 to put parts of my composed words, and fields trans1 trans2 trans3 to put the correspondant litteral translations.

I tried to create an auto entered calculation for trans1 trans2 trans3 but i dont know how to search the data in others records.

I also tried to create a seperate table with only the base words and created a relation with the main table using the lao word in common. But the calculation dont work too and it make me create an other table with duplicated data for nothing.

Here is my calculation

Trans1=

If (Lao1 = BaseWords::Laotien ;BaseWords::Francais ; " " )

Is there a better way to do this ? And what calculation for the auto-entered field do i have to use?

[paifu]

OK guys i just figured out the solution myself this afternoon. I post here my solution for those who have the same problem.

First of all, shame on me, I didn't know that you can create a relationship from a table towards the same table.

so from my main table LaoWords i created 3 self-link

LaoWords2 with the link Lao1 = Laotian

LaoWords3 with the link Lao2 = Laotian

LaoWords4 with the link Lao3 = Laotian

Then i transformed Trans1, Trans2 and Trans3 on calculation type field.

So all my records auto update themselves now witch is a much better solution than the auto-enter option who only update the new records.

Here is the calculations :

Trans1 = LaoWords 2::Francais

Trans2 = LaoWords 3::Francais

Trans3 = LaoWords 4::Francais

cya.