Thanks for the link.
I'm not really sure how that works, or how that script (?) should be edited to do what I want...
What I'm trying to do may be too difficult for a beginner.
It's not exactly a beginner's task, I'm afraid. Basically, you sort your records by State, then loop through them: for each group, you get the group's count (using a summary field defined as Count, and a calculation using the GetSummary() function) and omit the entire group if the count < 3.
So I perform a search in the "State" field entering "GetSummary(Count) > 3"???
Sorry for being dumb.. I'm not familiar with FileMaker's script language.
I did get it to sort, but nothing further than that.
I guess I could do it by hand, sorting and searching the particular field, deleting ones that appear less than XX times...
The problem is that there are like 100000 records, with about 1000 possibilites in the field; would probably take me a few months to get it done.
No, you cannot do this by performing a find - you must omit records by script.
There's a demo file in the thread I linked to - see if you can adapt it to your situation. I am afraid it would take too long for me to try and explain all of it.
Thanks! Didn't notice the demo file there.
I think the script in the demo file will be enough to adapt it to my database.
It's a lot easier to understand when you have an actual script to refer to:smileywink:
OK, I suppose it's not as easy as I thought.
I just changed the sorting, field's names and added the count field used in the script, but it's not getting the results I want.
hmm... time to give up?
Or try again - but begin by understanding how it works, rather than changing things blindly.
Thanks for the tip. I searched all the net on how the "GetSummary" thing works, and now I've got it to do what I want.
Another problem was that the script would not exit the loop properly. Fixed that and now it works.
Thanks for your help!
Good. BTW, in your situation you could speed up the script in two ways:
1. Start by finding duplicates (this will eliminate all groups of 1).
2. When sorting, reorder by the summary count field, so that groups are sorted by count, descending. Then you can loop until you get to the first group with count < 3, and omit all remaining records.