[AccessD] One-to-One relationships

jwcolby jwcolby at colbyconsulting.com
Fri Jul 20 08:14:07 CDT 2007


>Listen to the data.

And may the force be with you...

;-)

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, July 20, 2007 8:46 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] One-to-One relationships

Yes, if it has a purpose. A one-to-one relationship almost always flows from
need rather from the data itself. If you need to force a one-to-one, I'd say
do it. However, if there's no business rule saying, "there can be only
one..." it might be unnecessary, even if the data is presenting that picture
right now. Listen to the data. 

Susan H. 

Is there any purpose/advantage in creating a one-to-one relationship in a
database (e.g., CustomerId and CustomerName in one table and all the other
customer data (e.g., sex, address,  phone, etc) in another table?  


--
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