Multiple Values in a Field

  • Thread starter Thread starter Rush
  • Start date Start date
R

Rush

How can I make a database that will accept 2 or more
values in a particular field, where they will both be
under the same primary key? Also, if i put 2 values in
this particular field, there will be 2 values in the field
that follows it as well.

Thanks.
 
You can't and you shouldn't. Use multiple fields or multiple tables.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
How can I make a database that will accept 2 or more
values in a particular field, where they will both be
under the same primary key? Also, if i put 2 values in
this particular field, there will be 2 values in the field
that follows it as well.
Click to expand...

You're missing the point of how relational databases are designed to
work!

Fields should be "atomic" - have only one value.

If you have a one to many relationship, use two tables in a one to
many relationship. These two fields should be in a separate table,
linked to your main table; to conveniently enter data into both
tables, you can use a Form based on the "one" side table with a
subform based on the "many".
 
Back
Top