Lookup Allowing dups..
Posted: Sun Nov 14, 2010 8:34 pm
Hi All,
My requirement was ..
For example for iam doing lookup on COUNTRY field as below..
i/p
COUNTRY ITEM
------------ -------
X ds
Y sd
Reference
COUNTRY CODE
------------ ----
X 10
X 20
Y 10
o/p
COUNTRY CODE ITEM
--------- --------- ---------
X 10 ds
X 20 ds
Y 10 sd
I want to create new record for values having duplicates from reference dataset...
Does "ignore duplicates" option does this work or do i need to do any thing?
Thanks...
My requirement was ..
For example for iam doing lookup on COUNTRY field as below..
i/p
COUNTRY ITEM
------------ -------
X ds
Y sd
Reference
COUNTRY CODE
------------ ----
X 10
X 20
Y 10
o/p
COUNTRY CODE ITEM
--------- --------- ---------
X 10 ds
X 20 ds
Y 10 sd
I want to create new record for values having duplicates from reference dataset...
Does "ignore duplicates" option does this work or do i need to do any thing?
Thanks...