DK_Reddy

 Profile Answers by DK_Reddy Questions by DK_Reddy

• Dec 5th, 2010

 

NNNNNNNNNoooooooooooooooooooo

Nagaraju Puppala

 Profile Answers by Nagaraju Puppala 

• Feb 9th, 2011

 

Yes it's Possible.


Suppose the look up table contains the group values, and the primary is a combination of EMP_NO, DEPT_NO.

to get the EMP_NAME from the unconnected lookup, we should pass the EMP_ID, DEPT_NO.

in the lookup query we can compare like 'WHERE DEPT_ID=INPUT COLUMN(DEPT_NO)'

and lookup condition EMP_ID=IN_EMP_NO.

this lookup returns different values depending on the two input values.


here the two input values are used in different ways like one is used in the where condition, another is in the lookup condition.

its possible, try


Cheers :)

Nagaraju Puppala

Yoganand

• Aug 9th, 2011

 

Hi,

We can pull any number of columns in unconnected lookup nut with the help of Lookup override. We can concatenate many columns and then use an expression to deconcat those values.


Thanks,
Yoganand