Multivalued filed lookup

Hi

i have poseted my problem in previous post(ystday)

well, in simple if i have one or more than (ie multivlalued filed in view, combination of one or more field) , then how can i take db lookup them

say example, one row contain like,.

C Ramanadan,R jyoti,Vishnu prabhakar like

any focus on this will very much appriciated

DEV/\

Subject: Multivalued filed lookup

If I understand you correctly then you want to do a lookup based on each value of a multi-valued field. Use an @for loop, e.g. (& I pinched this straight out of the Designer Help)

For(n := 1;

n <= @Elements(Categories);

n := n + 1;

@Prompt([OK]; "Category " + @Text(n); Categories[n]))

All you need to do is replace the @prompt with the appropriate @dbLookup.