Jim Dettman
jimdettman at earthlink.net
Tue May 25 15:07:55 CDT 2004
Arthur, It's only the BE relationships that count, so you can simply delete them in the FE. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller Sent: Tuesday, May 25, 2004 3:33 PM 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