Show value from valuelist if field=part of value

[henrik_ahlgren]

A cryptic subject but I will try to explain the problem.

I have two fields, say "x" and "xcode", where I have a value list connected to "x". When you choose a value in the value list the "xcode" is set to a numeric value for example "1" if you choose the first value. This is performed through the calculation

 LeftWords(x; 1) 

---

Now I want it to work both ways because when I import data from another file to the database it usually only contains the numeric code. Is it possible to do this and how?

//Henrik

[djgogi]

Look at attachment.

Dj

[henrik_ahlgren]

Thanks for the answer, but I can't get the attachment. Could you please be so nice that you e-mail me it?