I would like to add a custom field from the Products object to the Opportunity Product object.  For example, for each product we specify a custom field call Product Family.  I would like to include that field in the product records listed in an Opportunity such that when I add/update an Opportunity Product item the correct Product Family value is displayed for the selected Product. 

 

So far, I've added a Product Family field to the Opportunity Product and I've setup a workflow rule to update the field on new/update of records.  To fill-in the value, I've tried to use ISPICK() and CASE() but I've reached a dead end.  Any help would be *much appreciated*.

 

Jeff