Lookup

[Hifive]

i have a resource file (1), for example:
APPLE;ONE
ORANGE;TWO
DURIAN;THREE
MANGO;FOUR
BERRIES;FIVE

I want bot to put the first column of items (APPLE, ORANGE ...) into Resource(2) as a selection list

If user picks APPLE from Resource(2), then Resource(3) will take the value of ONE.
If user picks ORANGE from the Resource(2), then Resource(3) will take the value of TWO
...

how can this be done?

Is there a better way?