Use three tables something like what's below. The has multiple entries
for each user. HTH.
--Jeff
tblUsers
PK_tblUsers
userName
firstName
...
tblSubjects
PK_tblSubjects
subject
description
...
tblUserSubjects
FK_tblUsers
FK_tblSubjects
On 7/21/2004 1:43 PM, Daniel Kessler wrote:
> I had a dropdown that had three entries: kinesiology, family studies,
> public and community health. So in my Oracle DB, I had a field TYPE
> VARCHAR2(100) to take that information, as is. Now I find that
> someone can be in more than one spot, so instead of a dropdown, I now
> have a checkbox for each entry. Is the standard way to deal with
> this to have three database fields like:
>
> isFamilyStudies INT,
> isKinseology INT,
> isPublicAndCommunityHealth INT,
>
> It seems kinda inflexible that I would have to add a row each time I
> added to that list, but if that's how it's done then ok.
> --
> Daniel Kessler
>
> Department of Public and Community Health
> University of Maryland
> Suite 2387 Valley Drive
> College Park, MD 20742-2611
> 301-405-2545 Phone
> www.phi.umd.edu
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- DB field setup Daniel Kessler
- RE: DB field setup Jeff Langevin
- RE: DB field setup Burns, John D
- Re: DB field setup daniel kessler
- Re: DB field setup Deanna Schneider
- RE: DB field setup Burns, John D
- Re: DB field setup daniel kessler
- Re: DB field setup daniel kessler
- RE: DB field setup Burns, John D