Lookup



  • 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?