Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X
All,
WF4.0, M270 Windchill 9.1 m010
I've been tasked with coming up with a new drawing format for our company. So far, so good. Now I'm working on the BOM table and need some relations in it. I don't deal with relations to much, so I'm not real comfortable with it an trying to figure it out through trial an error is time consuming.
Here is the situation. My description coloumn can have one of two different parameters used in this field. All of the files created within the last few years use a parameter called "title1". We've been migrating quite a bit of legacy data into Windchill, these are older files where the Title1 parameter was not popluated, but a parameter called "part_name" is used. So, basically, I want to create a relation to see if the part_name paramter was used, if it was not, use the title1 parameter. I've spent the better part of a day working on this and have been unsuccessful. Populating the Title1 parameter is not an option in these older files as when these files were migrated, they were place in a Released lifecycle state. Modifying the files would now require a revision. My relations in my repeat region are:
if exists ("drawing_no")
part_number = asm_mbr_drawing_no
elsepart_number = asm_mbr_part_no
endif
else
ENDIF
IF ASM_MBR_TYPE=="BULK ITEM"
quantity=asm_mbr_bulk_report_quantity
ELSEquantity=rpt_qty
endif