Building a Cross Reference Table

customaware

I have a BO called MyCode with one attribute called BaseCode

Records are, say,

A
B
C
D
E
F

I want to create another BO with every combination of pairs of the codes above....for example

BO - CodePair with two attributes... CodeFirst, CodeSecond

CodeFirst CodeSecond
A B
A C
A D
A E
A F
B A
B C
B D
B E
B F
C A
C B
C D
etc.. Etc

So I create a Process to loop thru all the BaseCode

Rule 1
FIND ALL MyCode IN BATCHES OF 1

Rule2
IF SEARCH_COUNT<>0
THEN FIND MyCode WHERE MyCode.BaseCode<>ThisMyCode.BaseCode

From this point I need to Create two records.
The first being

CREATE CodePair WITH CodePair.CodeFirst=ThatMyCode.BasedCode,CodePair.CodeSecond=ThisMyCode.BaseCode

The second being

CREATE CodePair WITH CodePair.CodeFirst=ThisMyCode.BasedCode,CodePair.CodeSecond=ThatMyCode.BaseCode

The problem I am running into is that I cannot do two consecutive CREATES in the same process as only the first gets executed

So ideally I would call a separate sub process for each CREATE. But, how can I pass both ThisMyCode AND ThatMyCode to the subprocess when the only thing I seem to be able to pass is MyCode?

Any pointers here would be appreciated.

customaware

Well....just in case anyone else bumps up against this problem, I thought I would share the solution.

Did not think of this myself. It comes from a bit of divine intervention from Support...... Awesome!

Thanx Vlad.

Two Processes.

Process 1 Called: LoopThruMyCode
FIND ALL MyCode
ProcessMyCode

Process 2 Called: ProcessMyCode (Input parameter MyCode)
FIND MyCode WHERE MyCode.ID<>ThisMyCode.ID IN BATCHES OF 1
CREATE CodePair FOR EACH OtherMyCode WITH CodePair.CodeFirst=ThisMyCode.BaseCode,CodePair.CodeSecond=OtherMyCode.BaseCode

Now to understand what it is doing.... 8-|