need special export

[susansan]

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

[sbg2]

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?

[susansan]

the multiple categories are in a related table.

[LaRetta]

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

[susansan]

Thanks so much LaRetta! I will give this a try.