I am trying to delete relationships between my tables from the relationship window. When I delete the tables, I say yes to save the changes. I close the database, open it, click on relationships, show all relationships and the tables are back again! I need to get rid of those relationships as I am having trouble with getting a primary key to enter data into a form. Any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can't Delete Relationships
- Thread starter ITProg
- Start date
- Thread starter
- #3
Relationship - the line thingie between those boxes thingies - you did right click that line, select Delete, hitting Yes on the message "Do you want to permanently delete the selected relationship from the database?"?
Mind you, if this is a front end, you'd need to to this in the back end.
Roy-Vidar
Mind you, if this is a front end, you'd need to to this in the back end.
Roy-Vidar
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question