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

enforce referential integrity after the fact?

Status
Not open for further replies.
patrichek

patrichek

MIS
Nov 18, 2003
632
US
is there a way for me to create a relationship between 2 tables and enforce referential integrity if one of the tables is already full of data?
thanks!
 
Sort by date Sort by votes
Only if the Parent table is full, not the child. Referential integrity means your not allowed to have Orphans. Only if life were like that.
 
Upvote 0 Downvote
haha...
ok, the parent table is the one with the data and the child is empty, but when i try to create the relationship, referential intregrity is grayed out?
 
Upvote 0 Downvote
nevermind,my bad...
i was trying to create the relationship on the front end...

thanks!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

v5652
  • Locked
  • Question
Trouble opening database Make sure the drive is available
Replies
2
Views
386
v5652
v5652
cortextual
  • Locked
  • Question
Referential integrity issue: no unique index found for the referenced field of the primary table
Replies
2
Views
347
MajP
MajP
1DMF
  • Locked
  • Question
Audit trail - referential integrity on deleted records 2
Replies
8
Views
165
johnherman
johnherman
BLSguy
  • Locked
  • Question
Referencing Totals from One Table in the Fields of Another
Replies
2
Views
115
BLSguy
BLSguy
MrMode
  • Locked
  • Question
Table locked after inserting a record with autonumber field value
Replies
2
Views
116
MrMode
MrMode

Part and Inventory Search

Sponsor

Back
Top