Deleting a foriegn ID from a multi-key relation

[agutleben]

I have a solution that uses a ID to Multi-Key ID relationship. I want to be able to delete the foriegn ID and break the relationship. I use the Replace script step with a calculated substitue:

Substitute(Device Software MULTI KEY::MultiKey Device ID;

Ttpro 7::g_Device ID & "

[Vaughan]

I do this in two steps: the first replaces the key with a blank line; the second removes the blank line from the multikey. The trick is to ensure that all the multikey values are paragraph delimited. You do this by adding a paragraph to the beginning and end of the multikey string. You also need to ensure the key to remove is paragraph delimited. This makes sure you substitute whole keys only, and not partial key strings.

I usually do these substitutions with Set Field steps in a script.

First step:

Substitute(

"

[agutleben]

Thanks Vaughan! That did the trick.

[-Queue-]

You can also nest these substitutions and trim the beginning and ending pilcrows in one step, if you like.

Let( S = Substitute(