Using a Lookup to display an Attribute in either English or French

[dhurtubise]

I need to have an attribut being able to display a name in french or english.
I got it done with a lookup, but i would like to be able to do it differently. Right now my look up as 2 Lookup Proerties, english and french. What i would like to have is :
Selecting english in the lookup and displaying the english name
Selecting french in the lookup and displaying the french name
Like that :

English : Microwave
French : Micro-Onde

that would allow me to select several blocks and switch them from english to french.
I can't use a visibility state since i"m using it for displaying the view of the block.

Any idea ?

[Rico]

I need to have an attribut being able to display a name in french or english.
I got it done with a lookup, but i would like to be able to do it differently. Right now my look up as 2 Lookup Proerties, english and french. What i would like to have is :
Selecting english in the lookup and displaying the english name
Selecting french in the lookup and displaying the french name
Like that :

English : Microwave
French : Micro-Onde

that would allow me to select several blocks and switch them from english to french.
I can't use a visibility state since i"m using it for displaying the view of the block.

Any idea ?
What about having only 1 lookup and it being for French? The original (default, if you will) can be english. That's the only idea I have. I think you've done it the best way possible.

[dhurtubise]

The thing is that it would allow me to change multiple block at the same time. I'm trying with linking to excel now

[clovis]

What about having 2 blocks on differents layers: English and French. turn off the one you don't want?

[Chris.N]

The thing is that it would allow me to change multiple block at the same time. I'm trying with linking to excel nowi've done tons with incorporating the vis state into my lookups, sometimes even replacing the vis state (node: 0) with a lookup.