I have a table called Caliber and it is shared between the Firearm table and Magazine table. Richard warned me and I didn't fix it at the time. I just realized this. So now i want to rename this table Firearm Caliber and create a new one called Magazine Caliber. So any pointers on what I need to do to make this turn out right. I am assuming I just need to create a new table and then correct the relationships between the corresponding tables. Is this correct or something else need to be done? I ahve made a copy of my DB and also a backup so I am covered there. Any pointers will be appreciated. I will accept Richard told you so...also...LOL