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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Disappearing Relationship

Status
Not open for further replies.
DanielCook

DanielCook

Programmer
Aug 7, 2002
3
US
Have an access 97 database w/65 table approx 500 queries. Not sure how many relationsips but it's quite a few. I attempt to create relationship between key fields. Line is drawn, with NO errors or messages. Relationship is one->many cascade delete & update. Next I save relationship screen then exit. When I go back to screen these relationships are gone.

Is there a limit on relationships?

What else could be causing this?
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
382
SkipVought
S
oxicottin
  • Locked
  • Question
Creating tables and relationships for new database
Replies
2
Views
2K
MajP
MajP
Moss100
  • Locked
  • Question
Property and Tenant tables - best approach for relationship 4
Replies
6
Views
137
dhookom
dhookom
MattGreer
  • Locked
  • Question
Managing Several Many-To-Many Relationships 1
Replies
8
Views
150
MattGreer
MattGreer
Kirk Thomas
  • Locked
  • Question
Table Relationships newbie needs help
Replies
8
Views
225
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top