Road Runner
mmattys at rochester.rr.com
Thu Jan 28 15:27:06 CST 2010
For queries, yes, but the tables should warn that they won't be able to enforce the relation on linked tables. ----- Original Message ----- From: "Dale_Anne Kalsow" <dkalsow at yahoo.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, January 28, 2010 4:17 PM Subject: Re: [AccessD] One-to-Many Relationship I have always created them in the front end before and not the back end. Dale --- On Thu, 1/28/10, Robert <robert at servicexp.com> wrote: From: Robert <robert at servicexp.com> Subject: Re: [AccessD] One-to-Many Relationship To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Date: Thursday, January 28, 2010, 2:46 PM I'm not sure I understand your question / problem... I pretty sure integrity control is governed by the back end database (where the actual tables are located). You cannot make relationship changes in the FE. WBR Robert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale_Anne Kalsow Sent: Thursday, January 28, 2010 3:31 PM To: Access Developers discussion and problem solving Subject: [AccessD] One-to-Many Relationship Good Afternoon, In Access 2007 I have a split database the table are held in a dat database and the application is in the app database with has linked tables to the dat database. Usually this is not an issue. Today, when I create a relationship in the dat database everything is fine. I can connect the table with the fields and check enforce refential integrity and cascase update realated fields check boxes. However, if I don't do it in the dat, when I go to make the save relationship in the app database these checkboxes are grayed out. I have delete the linked tables ane reattched them but sill have this strange behavor. Have anyone seen this before? thanks! Dale -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com