duplicate records showing

[ggh]

I've got a database with parent and student information. On one layout I've created a "find" portal based on Matt Petrowsky Many Faces of Portal Filters. The user types the first few letters of the parents last name and the portal filters to show matching records. It's worked great for several weeks, but we've found one instance where a parent shows twice in the portal. I've checked and there isn't a duplicate record. The duplicate show with 3 matching letters, not one, two or four. What's up with this?

[Vaughan]

I'll bet there *is* a duplicate parent record. Perform a find in the table. Also look for multiple values in the field that may be on a second line and not visible in a single-line field.