1 Reply Latest reply on Mar 28, 2013 8:23 AM by philmodjunk

    Help needed with relationship with creation of records

    MarcMcCall

      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