All,
I received quite a bit of help from the group, thanks to all. David provided me with some very good information, thanks again Mr. Haigh.
The problem I ran into was that most of the suggestions had relations to evaluate whether or not a parameter existed, if it did not, then a different parameter was used. Well, it turns out that both parameters were present in my models, they were not always populated. So the relation would be satisfied, but my drawing BOM for my description column would be empty, because the parameter was not populated in the model.
Turns out, I have a Relations genius working in one of our other facilities that saw my original post and provided the solution that works. Thank you Mr. Pothier. Here are the relations:
/* THIS RELATION WILL USE THE PART_NO PARAMETER UNLESS
/* THE DRAWING_NO PARAMETER EXISTS
/*
if exists("asm_mbr_drawing_no")==false
PART_NUMBER=asm_mbr_part_no
else
if exists("asm_mbr_drawing_no") & asm_mbr_drawing_no !="
PART_NUMBER=asm_mbr_drawing_no
else
PART_NUMBER=asm_mbr_part_no
endif
endif
/* THIS RELATION USES EITHER THE TITLE1 OR PART NAME PARAMETERS
/* TO POPULATE THE DESCRIPTION COLUMN
/*
if exists("asm_mbr_part_name")==false
DESCRIPTION=asm_mbr_title1
else
if exists("asm_mbr_part_name") & asm_mbr_part_name !="
DESCRIPTION=asm_mbr_part_name
else
DESCRIPTION=asm_mbr_title1
endif
endif
/* THIS RELATION IS USED FOR THE QTY. COLUMN. IF THE TYPE OF PART IS A
/* BULK ITEM, THE BULK_REPORT_QUANTITY PARAMETER WILL BE USED
/* TYPICAL VALUES ARE A/R, REF.
IF ASM_MBR_TYPE == "BULK ITEM"
QUANTITY = ASM_MBR_BULK_REPORT_QUANTITY
ELSE
QUANTITY = rpt_qty
ENDIF
I am sure there are other methodology that could accomplish the same end result, but for me, I am happy.
Regards,
Jeff Horacek
Engineering Change Management Specialist/
Global CAD Administrator
[STERISLogoColor-small]
STERIS Corporation
5900 Heisley Rd.
Mentor, OH 44060
P (440)392-7721
C (440)789-2629
F (440)392-8946
This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.
