I inherited this database. I had no control over it's initial build. As I have said before, an autonumber field would serve absolutely no purpose in this data table. I started this thread asking for help with a problem . I have had a few helpful replies but the overall trend is " where is the Primary key". And now, "why are you using a relational data base." None of this is addressing my problem so I thank you all for your time and I will sort it out myself. For my part it might take a bit longer but there will be much less angst.
Thank you.
Please consider this thread closed.
John