Get possible value ?

[#1]

Hi All,

     I have a problem that would like to see if anyone here can help me to solve.

If I have a table, let say

ID, Department, StaffName

1,Accounting, Peter

2,Accounting, Mary

3, Accounting, David,

4, HR, Sue

5, HR, Janet

So, if I choose Department = "Accounting", I would like to store "Peter; Mary; David" into a variable, just like the output of the function GETFIELDSELECTIONS. Any idea for this if I don't want to use any macro?

If there is no choice, how the macro will be?

Thanks a lot!!!

[#2 · Accepted solution]

Use concat(Department,'; ').

Regards,

Kiran Rokkam.

[#3]

Thanks Kiran.

It works!!