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]
[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 (2) |
Tidak ada komentar:
Posting Komentar