[AccessD] Another normalization question

Bill, this sounds similar to what Mark suggested. It sounds like the way to
go for me. 

Susan H. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson
Sent: Tuesday, September 16, 2014 3:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Another normalization question

I read recently a phone number table with FkPhoneType .... and I want to say
also, a FKBusinessEntityId. I am pretty sure i saw this in a sql server
sample database called adventureworks. I could be wrong, but I liked it.
That way a single phone number table works for all classes of entity
(people, and institutions).
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com