Relation

[WF_10971917]

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

[kdirth]

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 

[WF_10971917]

Thank you! I will give it a shot

[WF_10971917]

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]

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

[BenLoosli · Accepted solution]

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.

[WF_10971917]

What am I doing wrong?

[BenLoosli]

Is BOM_CAGE_CODE in your Local Parameters list as a string.

[WF_10971917]

Got it. Thanks!!!!