susansan Posted May 16, 2006 Share Posted May 16, 2006 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 Link to comment Share on other sites More sharing options...
sbg2 Posted May 16, 2006 Share Posted May 16, 2006 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? Link to comment Share on other sites More sharing options...
susansan Posted May 16, 2006 Author Share Posted May 16, 2006 the multiple categories are in a related table. Link to comment Share on other sites More sharing options...
LaRetta Posted May 17, 2006 Share Posted May 17, 2006 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 Link to comment Share on other sites More sharing options...
susansan Posted May 17, 2006 Author Share Posted May 17, 2006 Thanks so much LaRetta! I will give this a try. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6555 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now