The most dangerous soldier in battle is a new 2nd lt. with a map. In peacetime, it's me with self-taught Access capabilities... I now have a databse wtih about 1500 customers and family members. to search out the record for a particular family member, I have to scroll alphabetically through 1500 complete forms (headed with the parents' names) until I find the one with that person's name on it. The search fun tion only works if I use the name exactly as it's spelled, so if it's misspelled, if there's an extra space between first and last name, etc., it won't be found.
I was thinking maybe I could have a list of parents' names, clicking on which would open up the list of all forms headed by that parent. Does anybody have either tips on how to do that, or a better idea?