Ok attached I have my link tables in MS Access. The more info I am receiving the more frustrating this DB creation has been. It seems that adding all these primary keys with autonumbers just leaves useless information in my tables. Anyways, this question is referring back to my previous question about a Police Department Field Interview Database. I have attached my tables and links in hopes to have insight as to this being able to be a functional DB. Please let me know what you see wrong and possibly how to fix it. Will this allow me to search an officer to see all the subjects he has interviewed as well as being able to search a subject and find the interviewing officer? Please note that I have 4 different primary keys labeled ID's and I feel like all these autonumbered fields are going to interfere with real data. Thanks.