[AccessD] One-to-Many Relationship

Dale_Anne Kalsow dkalsow at yahoo.com
Thu Jan 28 15:17:46 CST 2010


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



      


More information about the AccessD mailing list