adding on ...
you can only enforce referential integrity if the relationship is in the same table as the tables. RI is important to ensure data integrity
Tip: Enforce Referential Integrity on Access Relationships (cc) closed-caption
http://www.youtube.com/watch?v=_zxxc9jzWEg
Warm Regards,
Crystal
*
(: have an awesome day :)
*
________________________________
From: Glenn Lloyd <argeedblu@gmail.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, October 31, 2012 8:40 AM
Subject: RE: [MS_AccessPros] Relationship Problems
You maintain relationships in the backend Bill.
Glenn
<mailto:glenn@rgservices.ca> signature block_OTM
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Singer
Sent: October-31-12 10:33 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Relationship Problems
I am having some relationship problems.I need help, I have been spending too
much time with my computer and my relationships are crumbling. (just for
fun)
Here is my relationship problem. I split the database. It appeared to be
working great. This morning I discovered a problem. Sometime in the last
week, since I split the database, one of my tables lost the primary key
designation, which erased a lot of my relationships between my tables. That
has caused problems with some of the queries. I figure out which one. I
corrected the primary key designation. Now my queries run fine. However,
when I go to the relationship screen in the Front end database and try to
reinstate the relationships I am not allowed to enforce Referential
integrity and cascade updates. Those options are greyed out.
Where am I supposed to establish the relationships? In the front end or the
back end?
Thanks,
Bill Singer
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar