[AccessD] One-to-Many Relationship

Max Wanadoo max.wanadoo at gmail.com
Thu Jan 28 14:37:26 CST 2010


Dale,

For linked tables, set up the relationship in the BE.

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale_Anne Kalsow
Sent: 28 January 2010 20:31
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





More information about the AccessD mailing list