Rabu, 31 Oktober 2012

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]

[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)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar