Value List Lookup to second field

[tmas73]

Hi,

I have one field that displays a second value lookup as popup menu. I do want to have the same result in a second field. So once I chose the popup and it displays the second value the other field should display the same value. In my set up now the second field just displays the value list of the first value (record serial). How by calculation of the second field can I display the second value?

[mr_vodka]

you can use a relationship keyed from the first field to the same table used for your value list and then display the value (or lookup) from there.