Greetings all!

Here's a fun little problem I just ran upon. My program is setup to look up a serial number specified by the user and see if it's in the database. In my code one of the first things I've done is "SET DELETED ON" so that deleted records are SUPPOSED to be ignored. Here's the fun part:) Over time alot of new records have been added, and deleted. Well now we're at the point where 2 records have the same serial #, however, one record is deleted, the other is not and is correct and up-to-date. So when I do a SEEK on the serial #s, shouldn't it ignore the deleted record and find the good one? Currently, the good record is below(in the index) the deleted record, and I guess that's why the SEEK returns EOF with no records found....is this right? Any thoughts? Please reply if you need further clarification on this. Thanks in advance for any help you can give:)

John