Hello everyone!

Maybe someone here can help me.  I am using the property tab builder to create custom properties for parts, assemblies, and drawings.... I am going to use these properties for many uses, one being my companies BOM.... I already have a spreadsheet that has our stock part numbers and descriptions and in it, for example, in column B is the stock part numbers, and in column F is the stock part description.... I want to have a custom property that is linked to the spreadsheet for the stock part numbers (no problem), and I want to have a custom property that is linked to the spreadsheet for the stock part description, BUT I want that custom property to automatically update to the correct description based on whichever stock part number I've selected. Make sense?

Thanks,

Josh