Search Script Problems
I have a music student database I made (Filemaker Adv 10 + OSX 10.5.8) that tracks attendance in sectionals and rehearsals.
In my sectional table, I have script that runs to make sure that you don't created duplicate by searching my date and sectional name. I was working fine, until today. I have a sectional called "Low Brass A" and one called "Low Brass B". When the script runs and searches for "Low Brass B", it returns "Low Brass A" as a match in the find, but it won't do the same with sectionals called "Trumpet A" and "Trumpet B". Does that make sense. What am I missing....