Not able to delete record, Access 2003

[dawnd3]

Hi there, I have a table called "tblMemberInfo" that has a blank record. The only thing in this record is the member id. I am trying to delete it but keep getting the message that I can't delete it because "tblMemberInfo" has related records. I do have this table related to itself in the relationships because there is a field that selects a members name as how they were introduced. However, this particular record is NOT referenced in that field. I also checked to make sure the member id doesn't show up anywhere in any related table, and it does not. This just seems a little buggy to me but maybe I am missing something. Anyone have any ideas? (And believe me when I tell you that I am pretty good with table design and relationships. So this is really stumping me.

Thanks,

Dawn

 

[dawnd3]

Nevermind, I figured it out. They had a feild they weren't using anymore that was referencing this record.

Dawn