Counting occurences for the same name in a file
I have a layout that requests the user to select a name from a pull down list. Once selected, I need a script that will count how many occurences of that name are in the database table/file before moving on to the next layout field (the selection of the next field the user tabs into is based on the count result). I have had limited success writing a script that works; the only time I get anything close to what is needed is if I commit the record immediately after making the name selection (which poses other issues since I need to be in edit mode throughtout the process). Anyone have a simple script to use (I suspect a loop is involved but I sure can't figure out how...)?