Problem with grouped export missing records
I am creating a classified ad database that will need to export the ads running on a certain day to an XML file to be imported into Indesign.
All is going well untill I try to group the ads by classification.
I either get the first ad of each classification
Or I get all the ads with the classification in front of them
Class 1 Ad 1
Class 1 Ad 2
Class 1 Ad 3
Class 2 Ad 1
Class 2 Ad 2
what I want is
I currently have a seperate layout set up with only the ad copy and the classification number. I set up the classification number as a group field in table view so it would be an option in the export.
Any tips would be appreciated. Also, I'm a Novice, but I'll try not to get lost in any descriptions.