So i've got this database i have to make for business studies and i'm stuck as to how you delete the relationships for the tables 
anyway in the tables i have i need to change the primary keys from text fields to autonumber fields to do this it states that i have to delete the relationships i made for the tables so i do the clear layout ...doesnt work..... i then used the delete button found on the home tab for each table..... still doesnt work..... how in the hell do i delete the damn relationships its really preventing me getting any further and is driving me up the wall
by the way its Microsoft Access 2007
Thanks
Leon
anyway in the tables i have i need to change the primary keys from text fields to autonumber fields to do this it states that i have to delete the relationships i made for the tables so i do the clear layout ...doesnt work..... i then used the delete button found on the home tab for each table..... still doesnt work..... how in the hell do i delete the damn relationships its really preventing me getting any further and is driving me up the wall
by the way its Microsoft Access 2007
Thanks
Leon
