PC Review


Reply
Thread Tools Rate Thread

One field, multiples entries

 
 
Patrick Stubbin
Guest
Posts: n/a
 
      3rd Jun 2010
Many eyars ago I used a database language called "PICK", this enabled you to
have a field with multiples entries in one record of a table. I read
somewehre that Access 2007 had this capability, I cant find areference to
this, can 2007 do this?

Rather than have a table referencing a second sub table

Pat
 
Reply With Quote
 
 
 
 
Jörn Bosse
Guest
Posts: n/a
 
      3rd Jun 2010
Am 03.06.2010 01:09, schrieb Patrick Stubbin:
> Many eyars ago I used a database language called "PICK", this enabled you to
> have a field with multiples entries in one record of a table. I read
> somewehre that Access 2007 had this capability, I cant find areference to
> this, can 2007 do this?
>
> Rather than have a table referencing a second sub table
>
> Pat


Hi,

in Access 2007 it´s posible to do so.
Create a table and add a new field as a combobox. Then you can choose:
Allow multiple entry yes/no.

Regards
Jörn
 
Reply With Quote
 
 
 
 
Access Developer
Guest
Posts: n/a
 
      3rd Jun 2010
Using the ACCDB form of databases, it is possible to define a multi-value
field. However, you will find it a "royal pain" when you want to use it
later in queries. That is why most of the experienced relational database
developers I know will suggest that you do what you then describe: a table
with a linked related table. Believe me, it will save you grief in the long
run.

Many are convinced that this capability was added only to be able to support
existing data in SharePoint Lists.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"Patrick Stubbin" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Many eyars ago I used a database language called "PICK", this enabled you
> to
> have a field with multiples entries in one record of a table. I read
> somewehre that Access 2007 had this capability, I cant find areference to
> this, can 2007 do this?
>
> Rather than have a table referencing a second sub table
>
> Pat



 
Reply With Quote
 
Jeff Boyce
Guest
Posts: n/a
 
      3rd Jun 2010
Patrick

I'm with Larry ... yes, you can, but WHY?!

Sticking more than one fact in one field means locating the one fact among
many in the field just got that much more difficult!

Far easier to use related tables ... and you seem to be describing a
one-to-many relationship. One record in your (main) table could have zero,
one, or many related records in a second table.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Patrick Stubbin" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Many eyars ago I used a database language called "PICK", this enabled you
> to
> have a field with multiples entries in one record of a table. I read
> somewehre that Access 2007 had this capability, I cant find areference to
> this, can 2007 do this?
>
> Rather than have a table referencing a second sub table
>
> Pat



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Increase clipboard entries; find clipboard that holds multiples Chad Harris Windows XP Customization 3 28th Oct 2005 02:13 AM
grouping text from multiples records into one field =?Utf-8?B?cGhvbGFz?= Microsoft Access Queries 1 28th Jun 2005 06:31 PM
WinXP ; How to transform multiples Prints into one ? Gadget Printers 7 29th Nov 2004 05:03 PM
Multiples entries Floyd Forbes Microsoft Access Forms 1 5th Aug 2004 12:12 PM
Multiples users of one DB? Jason Microsoft Access 3 20th Feb 2004 05:01 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:12 PM.