How to assign a value for Qualifier field based on some condition

[Former Member]

Hi Gurus,

I would likes to ask one query below

I have a main table with 3 fields CID,CNAME and Relationship(Lookup[Qualifier])

Relationship(Qualifier table) has two fileds TYPE(Quaifier=No), MDMID(Qualifier= Yes)

In Maintable i have a record of customer

101 X TYPE=SOLD-TO MDMID=102

102 Y

First record has MDMID value is second records CID and TYPE= SOLD-TO now i want to get vice versa like

102 Y TYPE=BILL-TO MDMID= 101

in the same way i want to apply for number of records

Could any body make me clear about this issue. Best answer will be appreciated

[Former Member]

I got the answer

[Former Member]

Hi Yugandher,

Sorry mate your statement below is very confusing ..Will you please make it clear

First record has MDMID value is second records CID and TYPE= SOLD-TO now i want to get vice versa like

+102 Y TYPE=BILL-TO MDMID= 101

Still not able to understand your question?

Vikrant M Kelkar