Creating value set

[Habtamu E]

Dear Team,
How are you?
I have difficulty creating a value set from two different lookups. One is a single occurrence, and the second one is a multiple occurrence. If you have a solution, please let me know.
Thank you.

[Gregory Martin]

You posted an application here: https://www.csprousers.org/forum/viewtopic.php?t=6603

However, you did not give a description of the problem that you are facing. You have this code:

PROC FARMID_K

preproc

    numeric c;
    ValueSet FarmK_vs;

    do varying c=1 until  c > totocc(WOREDA_DICT.WOREDA_REC);

        forcase WOREDA_DICT where  FRAME_LOGIN_WOREDA=FRAME_LOGIN_KEBELE  do
            FarmK_vs.add(FRM02_W(c), FARMID_W(c));
        enddo;

    enddo;

But you do not assign the value set to a field like this:

    setvalueset(FARMID_K, FarmK_vs);

Can you give more details about what you are trying to do?

[Habtamu E]

Thank you Gregory