[AccessD] Ooops!

You should see the BE relationships in the FE without creating them
there, although the layout may not be pretty.  The Enforce RI checkboxes
are unavailable in the FE on relationships declared in the BE and on
relationships either in the BE or between the FE and BE.  Just delete
the FE relationships unless you have some on FE tables.  The FE inherits
relationships from the BE.

Charlotte Foust

-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com] 
Sent: Tuesday, May 25, 2004 11:32 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Ooops!


Ok, we all know I'm prone to idiocy, but that aside....

I have been hopping between FE and BE and I declared relationships in
the FE thinking that I was in the BE. The declarations now conflict. (I
finally realized that something was wrong because the "Enforce RI"
checkboxes were unavailable.)

So... The question is, how to fix it. The relationships are all correct
in the BE and a few are wrong in the FE. If I delete all the
relationships in the FE, will that fix it? If I do nothing, leaving
conflicting definitions, what will happen? What I wish is that within
the FE, I will simply "see" the relationships declared in the BE. (What
I also wish, but that is another story, is that this would work as it
does in ADP files, where you can have multiple diagrams, each devoted to
a subset of the data.)

Recommendations? Should I just kill all the relationships and the whole
diagram in the FE? 

TIA,
Arthur

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com