complex looping and exporting in script interface

[datafirm]

Hello all,

I have a solution that I am working towards and I have the flow of the project layed out, I just need some advice on how to get the filemaker portion done. Let me go throught this part by part and see what you all think. Thanks!

All the data is going to be exported in some form to XML, I am then going to process this with XSL to get HTML pages.

The first part, I am going to need out put that lists every item in a list and each unique item from another list that is associated to that list.

Example: I have states in a list, four or five states, I then have a list of locations, of coures in all these records when a certain state is selected, there will only be a number of the items in the location lists that would be selected for any state. I want to get the export in XML in a way that I would avoid any duplicate records as far as having the same location as another record for that state.

I am not sure how one can control the format of the XML output? I can work with the output, but it would be nice to have have each unique state only have rows of the unique locations from the records that were found.

I know one will have to loop through each state and then perform a find on that state. Then I persume one would need to just return unique fields from the location list.

The second part is a bit easier on the filemaker side. I have to loop through each unique location and then perform a find to get all records and export them exporting that set as XML and creating a file with XSL I will be suing a plugin for the file naming.

Any help or ideas on how to get this filemaker looping done and exporting tops on XML will be greatly appreaciated!! Optimization ideas and other approaches are also welcomed!

Thanks in advance