Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can you link multiple properties into one column on a BOM? 1

Status
Not open for further replies.

SWUSER71

Marine/Ocean
Joined
Aug 10, 2010
Messages
22
Location
US
I want to link multiple custom properites to one column on a BOM. Does anyone know how to do this?
I wan to take 2 custom properties
Description
Size

and show them in the same column as
Plate - 1/2" THK
 
I did it with the Excel-based BOM and it was a P-A-I-N!

Perhaps you can have two columns and hide the vertical border?
 
You could also combine custom properties into a single property, and call that into the BOM.
 
SWUSER71,

You can construct text strings in Excel consisting of elements of the other cells. Note the ampersands connecting each element in the cell.

Cell B2=3.14159265897
Cell B3="M2.5x0.7"
Cell B1="SCREW "&B3&" LONG X "&B3

Resulting cell B1...

SCREW 3.14159265897 LONG X M2.5x0.7

Critter.gif
JHG
 
Thanks CorBlimeyLimey!!
That's what I wanted... just didn't know what to search for.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top