Primary Key with dup records :)

Hello everyone,

I have a form that is linked to a table in access, and am having an issue. I'm currently having it use the autonum to row as the primary key as, however when I do my search against that table the following happens:

example: There is a record for John smith with ID # 15 and I add a record and the autonum gives it 15000. So there are two row for John smith ID # 15 and 15000. On the table they are right next to each other, but on my form when I do my search it only brings up the first one (15) and when I scroll it crolls based on the ID #, so it'll take me a while to get to 15000. :)

Is there a way to do a search on a form that will bring in all like records based on the seacrh info, i.e. name, SS#, etc. Or is this a primary key issue. PLEASE HELP this is making me pull my hair out :)

re: Primary Key with dup records :)

You mean filtering the forms?

Also, your primary key doesn't have duplicate records. Your name field has duplicate records. If the name field is truly the key field then you should make it the key field.