[AccessD] Re: Checkboxes/MultiSelect Listbox - What's Best?

Terri,

The best way, according to normalization rules, is to store
it in a SelectedPrograms table.  You would also have a table
tlkpPrograms to use for a list of valid programs.  By doing
it this way, they can add new programs without you having
to change the program to handle it.  If you use check boxes,
you would have to add new ones and remove existing ones as
the program list changed.

If you want, you can send me the current structure off list
and I will look at it and give you suggestions about how to
get it fully normalized.

Robert

At 12:41 AM 2/17/2004 -0600, you wrote:
>Date: Mon, 16 Feb 2004 15:56:20 -0600
>From: "Terri Jarus" <jarus at amerinet-gpo.com>
>Subject: [AccessD] Checkboxes/MultiSelect Listbox - What's Best?
>To: <accessd-owner at databaseadvisors.com>
>Message-ID: <s030e829.019 at an-mail.amerinet-gpo.com>
>Content-Type: text/plain; charset=US-ASCII
>
>I'm redesigning an existing database that is not fully normalized.  Here 
>is an example where I'm not sure the best way to handle.  Current db has a 
>field (Boolean) for each program:  AS, DI, MS, SS, LB, NU for example and 
>the user checks the applicable box(es) that are related to their contract.
>
>I was going to use a Multiselect Listbox and have it save a string value 
>to the field Programs - but, I would  need the string value to be in a 
>consistent order.
>
>Another idea would be to save a record for each program in a Programs table.
>
>Which is the best route to follow?  Any suggestions?
>
>If you need more information, just let me know.  Thank you for your input.
>
>Terri Jarus