I have an assembly where I inserted a number of different bolts and washers. When I insert a Bill of Materials it lists the name of the bolt under part no however they are commercial parts so I do not want any part number associated with them. Is there a way to move the text from the part number column to the description column without breaking the link?
Do you have a property inside them specifying that they are commercial parts?
If so, you can use an IF statement in the description column. "If they are commercial, list the part number, otherwise the description".
Same for the part number column. "If they are commercial, list "" if not list the part number".