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!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Relationships deleted in relationship window.

Status
Not open for further replies.
losthorizon

losthorizon

Technical User
Nov 7, 2001
63
US
When I create a relationship between any two tables in the relationship window, enforcing referential integrity and cascade deletes, it is created without any error messages.

When I go back in, the two tables are there but the line showing the relationship is deleted. The tables then behave as if there is no cascade delete relationship.

I am running access2000 and have linked tables that also have relationships. These linked tables show fine and work fine. Any ideas?
 
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
986
renigar
renigar
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
1K
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
TrekBiker
  • Locked
  • Question
Style change after Windows Update
Replies
0
Views
521
TrekBiker
TrekBiker
Trob70
  • Locked
  • Question
There is no object in this control 1
Replies
9
Views
913
Trob70
Trob70

Part and Inventory Search

Sponsor

Back
Top