[AccessD] One-to-Many Relationship

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 




More information about the AccessD mailing list