Sort order prior to export omitting duplicates?
I've encountered a possible glitch in Filemaker Pro 11. I wrote a script to export records that included a sort order step that sorted all the recorded by last name. But I've discovered that for some reason the step keeps omitting duplicate last names. Its bizarre... Can anyone explain why this would happen. My script is pretty simple:
Sort Records (by Last Name)
That's it! In the export record step I also tell it to group by Last Name but it doesn't do it for some reason, hence why I wanted to add a sort record step.
Why would it omit duplicate the last names? And while we are here, how can I get it to sort by Last Name if I can't use the sort order script step.