Help needed with relationship with creation of records
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.
I would suggest that you remove these 6 fields from Products and just have these three fields in Attributes:
SKU, Attribute_value, Attribute_name
Then you would enter this data into the related Attribute table from the start rather than copying the data into it from Products.