Relation

Question

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

BenLoosli · Accepted Answer

IF asm_mbr_part_number=="12345"BOM_CAGE_CODE="96906"ELSEBOM_CAGE_CODE=asm_mbr_cage_codeENDIF The one additional step is to use &rpt.rel.bom_cage_code in your cell in the BOM.

kdirth · Answer

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

Select “Repeat Region” from “Table” tab
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
Select “Repeat Region” from “Table” tab
Select “Switch Syms”
Select “Relations” then select the table.
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
Select OK
Select “Update Tables” from menu then Done.
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

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded