RE: multiple values
From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 08/16/04
- Next message: AshleyT: "pad char with leading zeros"
- Previous message: Snake: "How to get Raiserror message from trigger from a stored procedure"
- In reply to: Ezekiël: "multiple values"
- Next in thread: David Portas: "Re: multiple values"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 16 Aug 2004 12:57:01 -0700
May be storing each option as an independent row in another table. You can
find more information reading about "Normalization".
Example:
create table customer (custID int nor null primary key, ...)
create table color(colorID int not null primary key, ...)
create table customer_color(custID int not null references
customer(customerID),
colrID int not null references color(colrID),
...
constraint pk_customer_color primary key (customerID, colorID))
AMB
"Ezekiël" wrote:
> Hi,
>
> Does anyone has a some good advice/example how to store multiple values for
> a field.
>
> For single choice fields, i use a combobox in access and the value will be
> an integer number, but how about when a field has multiple choices? Should i
> use a listbox with multiple select enabled for visual appearance.
> If i choose that option how should the value be stored? The sum of 2 or more
> choices. But then again i will get stuck for example if a user chooses 2
> choices with a value of 1 and 3. The sum of that is 4, but that could be the
> value of choice option 4.
>
> I'm running out of ideas, can anyone help me on this?
>
>
>
- Next message: AshleyT: "pad char with leading zeros"
- Previous message: Snake: "How to get Raiserror message from trigger from a stored procedure"
- In reply to: Ezekiël: "multiple values"
- Next in thread: David Portas: "Re: multiple values"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
