Look Up in Assignment
We have requirment ,we are maintaining one cross reference table where we are maintaining emails Ids and group.(this cross reference is not linked to main table)
Group1 123 email.com
Group2 xyz email.com
and group field is also maintained in one qualified table.
we want to do assignment in a way that whenever record belongs to group1, in Assignemnt we have to do lookup in that cross reference table. so in assignment for that perticular group we have to do lookup for email address and assign that email address to email ID field in main table.
Can we use lookup table that is not linked to main table in assignment ?
So instead of maintaing emails in assignment we are maintaining that in one cross reference table.
your inputs on how i can do lookup in assignemnt will be highly appreciated