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...
You have a design issue. You should use a serialized key field (match field) to related the records. The key fields in a relationship should never change. Only in a few circumstances would you use any other method. You would create a Auto-Enter calculation field to auto enter a serial number this will be your match field in the Parent table.