Value Lookup

Can you confirm the dynamics product you are referring to please

Apologies it is Microsoft Dynamics CRM 2016 (on premise)

Is there a 1:n relationship from your call entity to case?  If so, you should be able to use relationship mappings to have the auto-number field copied to a text field on case.

Please feel free to post again if you need more help on this.

The Case itself could end up having many calls associated with it; however, that initial Call will be converted to 1 (and only 1 case).  That is to say, at the time I want to pull that autonumber off the Call object, there will always only be a 1:1 relationship between the two.    Thereafter though, the user could receive more calls and attach them to that 1 case.   Is that what you mean?

Yes, that is what I wanted to know. It sounds like you have a 1:n relationship between Case and call (is call a custom entity?) where a case can have many calls but a call can only be linked to one case.  This means that relationship mapping can't be used to copy over the auto number field because relationship mapping applies when adding a child record to a parent record - this is the opposite of your scenario.

So, to copy over the auto number field you either need to change the process that converts the call to the case (again, is this a custom development ?) to also copy over the auto number field or you will need some other custom development.

What do you envisage happening if another call is added to the case, would the auto-number field be over-written by the latest call?

Thanks that makes sense.    Any subsequent calls would also receive an auto number (just because we built it on the standard call form, NOT a custom entity).    The initial call though, is the only one for which we wish to elevate the autonumber.

OK, I think you are using the out of the box convert phone call to case dialog. I don't think there is a way to customize that dialog to also copy your auto number field. I think you will need a custom development to run when a new case is created, the code will need to check if there are any calls linked to the case and if there is only one, then to copy the autonumber. I don't think there is a simpler, non-code way to do this.

Ok, thank you that helps.    So is what you are suggesting actually using custom entities?  Or just inserting script which runs against the existing Call and Case entities?  I believe it is the latter but just want to confirm.

Prefect, thanks for your help feridun.