AnsweredAssumed Answered

Help needed with relationship with creation of records

Question asked by MarcMcCall on Mar 28, 2013
Latest reply on Mar 28, 2013 by philmodjunk

Title

Help needed with relationship with creation of records

Post

     Hey all,

      

     having a hard time with this relationship.  I have 2 tables T15_Products and Attribute_Export, I'm working with.  T15_Products is where all of my product info is.  I have 7 fields I want to work with from T15_Products to create records in Attribute_Export.

     sku_item_code = Keyfield (unique)

     Atribute_Value1 = Autoenter Calc

     Atribute_Name1 = Autoenter Calc

     Atribute_Value2 = Autoenter Calc

     Atribute_Name2 = Autoenter Calc

     Atribute_Value3 = Autoenter Calc

     Atribute_Name3 = Autoenter Calc

      

     What I'd like to accomplish is if sku_item_code and Atribute_Value1 have a value it creates a record in Attribute_Export, and the same for sku_item_code and Atribute_Value2 and sku_item_code and Atribute_Value3.  This would have the potential to create up to three records per sku_item_code in table Attribute_Export.

      

     My final result needs to be able to be exported like this in an excel format:

      

     Item Code  Attribute Name  Attribute value
     Promo1  Colour  Cyan
     Promo1  Type  OEM
     Promo1  Part Description Toner Cartidge
     Promo2  Colour Magenta
     Promo2  Type Compatible
     Promo2  Part Description Toner Cartidge

      

     Any assistance would be appreciated, or a better idea.

     Marc

      

Outcomes