Simple db table design question
From: Jon Maz <jonmaz_at_surfeu.de.no.spam>
Date: Tue, 18 Mar 2003 16:17:43 +0100
Message-ID: <b57d62$2s2$1_at_news.online.de>
Hi,
Date: Tue, 18 Mar 2003 16:17:43 +0100
Message-ID: <b57d62$2s2$1_at_news.online.de>
Hi,
For my tblPeople, I want fields for HomeEmail, WorkEmail, and BestEmail,
where BestEmail is the default address you use to contact the person (in
this simplified scenario, either HomeEmail or WorkEmail). I am trying to
decide between a few ways of doing this.
METHOD 1
There are probably some other ways of doing this as well. Does anyone have any advice on the pros and cons of the different methods, and in which situation one method or other is preferable?
TIA, JON Received on Tue Mar 18 2003 - 16:17:43 CET