May 16, 200619 yr If I have an item record that has multiple categories, I need it to export with the redundant data as follows: Sterling Silver Ring 19.99 all-rings Sterling Silver Ring 19.99 stoneless-rings Sterling Silver Ring 19.99 pave-rings etc.... for all my products. Is there a way to do this? right now it exports like this: Sterling Silver Ring 19.99 all-rings stoneless-rings pave-rings
May 16, 200619 yr Are the multiple categories in the same table or a related table? If the same Table then are all the catagories in 1 field or multiple fields?
May 17, 200619 yr Hi Susan, If you are getting ONE Item with each of it's related 'multiple' categories, it means you are in the wrong table for your export (to meet your specific need). Try switching your perspective to your Category table (your many side). Perform your find, select your MAIN Item field and Price field, then select the category field. In this way, each line will be a category but it's related (Main Item and Price) will export on the same line. LaRetta
Create an account or sign in to comment