Deleting a row from tables that have one to one relationship

Topic

New Reply

My database has two tables, and these tables have One-to-One relationship among each other(By Primary key of each table) , data entry to these tables is done by Data Entry form that I have created, I have entered a wrong Primary key which is common to both tables, I want to correct it but it gives me an error “It is not possible to delete it because it is shared with another table”. I what I did was that I have deleted their Relationship first and then I have corrected the primary key in both tables, and after I have established a One to one Relationship again. I don’t know whether we have a better solution for that or not, If yes your help will be highly appreciated.

Thanks a lot

Reply | Quote

Replies

I would love to see that database, just a few dummy records in both tables would be sufficient

Reply | Quote

what database application are you using?

Reply | Quote

The bottom line is that the approach you took is the correct one, and about the only choice. That said, most designers end up using an auto-number field as the primary key, and true one-to-one relationships are rare things unless the database isn’t normalized.

Reply | Quote