Record information replaces when I delete relationship!!!
Hi, I have a file with 70 records. Each record is identified by an ID field and the person name.
The ID come in pairs and the difference would be in the person name...
ID: 1 - NAME: Mariana - Related Information: A
ID: 1 - NAME: Lucia - Related Information B
ID: 2 - NAME: Maria - Related Information: C
ID: 2 - NAME: Juan - Related Information D
Each record has two tables which are related with the ID and the name. I tried to delete the relationship with the name (because there were mistakes in some names and when I want to change them, all the related information deletes!!!) but when I do that, the pair of the ID replaces the other one, like this:
ID: 1 - NAME: Juan Osorio Díaz - Related Information: A
ID: 1 - NAME: Lucia - Related Information A
ID: 2 - NAME: Julio Juan Gutierrez - Related Information C
ID: 2 - NAME: Juan - Related Information C
How can I delete the relationship avoiding that the information of one ID replaces the other one...