I am using a one-way map to pull Name, Address, Phone and Email from Evo to UPS Worldship. I initially was using the email from BKARCUST, but that is not updated any more(?) so I went to BKCMACCN. It's working but I sometimes get a strange result.
 
After entering the SO number in the Import Key box to pull in the data, I'll get a message like "[some number] records found for the key value [so number]. Using data from the first record found". Doesn't always happen, and the number varies - I've seen between 3 and 8.
 
My Primary Key is  
BKAR_INV_SONUM.
 
I have Foreign Key Relationships of  
BKARINV:BKAR_INV_CUSCOD --> BKARCUST:BKAR_CUSTCODE
BKARINV:BKAR_INV_CUSCOD --> BKCMACCN:BKCM_ACCN_CODE
 
I suspect it has something to do with the FKRs, as when I was first adding the BKCMACCN email I had the second FKR set as  
BKARCUST:BKAR_CUSTCODE --> BKCMACCN:BKCM_ACCN_CODE
and would get that message on every SO, and then every time the number of records found was 1297(!)
 
The only thing I'm currently using from BKARCUST is the Telephone #. Unfortunately not all BKCMACCN records have a phone, so we can't use just that table.
 
Any ideas?

Ok, I see.
 
Is there a better way to get an email address into UWS?