Skip to main content
W
WF_1097191712-Amethyst
12-Amethyst
February 5, 2026
Solved

Relation

  • February 5, 2026
  • 1 reply
  • 264 views

Hi,

 

Can someone help me to create a relation in a bom to change a parameter to another number for cage_code? I have something at the bottom of the relation in the bom table that is obviously incorrect.

 

I have attached a simple drawing in creo 8. If you can perform the task and return to me then I will understand how it is done. Should only take a guru less than 5 minutes.

 

Wayne

Best answer by BenLoosli

IF asm_mbr_part_number=="12345"
BOM_CAGE_CODE="96906"
ELSE
BOM_CAGE_CODE=asm_mbr_cage_code
ENDIF

 

The one additional step is to use &rpt.rel.bom_cage_code in your cell in the BOM.

 

1 reply

kdirth
21-Topaz I
kdirth21-Topaz I
21-Topaz I
February 5, 2026

Here are instructions to create the relations to change specific Cage_Codes. Hope this helps.

 

  1. Select “Repeat Region” from “Table” tab 
  2. Select “Switch Syms” then “Done.” 
    1. Double click on first item cell 
    2. Select rpt… then rel… then User Defined. 
      1. Type in Relation name- MY_CAGE_CODE 
  3. Select “Repeat Region” from “Table” tab 
  4. Select “Switch Syms” 
  5. Select “Relations” then select the table. 
  6. Enter text to make change required and select OK/Done. 
    • IF CAGE_CODE==30003 
    • MY_CAGE_CODE=CAGE1 
    • ELSE 
    • MY_CAGE_CODE=CAGE_CODE 
    • ENDIF 
  7. Select OK 
  8. Select “Update Tables” from menu then Done.  
  9. Multiple changes in a column can be done by nesting IF statements: 
    • IF CAGE_CODE =="12345" 
    • MY_CAGE_CODE="67890" 
    • ELSE 
    • IF MY_CAGE_CODE=="012345" 
    • CAGE_CODE="34567" 
    • ELSE 
    • MY_CAGE_CODE= CAGE_CODE 
    • ENDIF 
    • ENDIF 
      • One ENDIF for each IF statement 
There is always more to learn.
W
WF_1097191712-AmethystAuthor
12-Amethyst
February 5, 2026

I am not getting this to work. Is it possible you can edit the sample I sent and send it back? I will see what you did to get it to work.

 

Is it possible to say IF the part_number parameter is XXX that this is cage_code?

 

What happens if the cage code is empty from the start?

kdirth
21-Topaz I
kdirth21-Topaz I
21-Topaz I
February 5, 2026

I did this in Creo+ (13.1).  Here is what I got to work:

 

IF asm_mbr_part_number=="12345"
my_cage_code="96906"
ELSE
my_cage_code=asm_mbr_cage_code
ENDIF

 

I did step 2 above to create my_cage_code in the table

There is always more to learn.
Terms & ConditionsCookie settingsAccessibility statement