A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

One field, multiples entries



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2010, 12:09 AM posted to microsoft.public.access
Patrick Stubbin
external usenet poster
 
Posts: 5
Default One field, multiples entries

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
  #2  
Old June 3rd, 2010, 01:18 AM posted to microsoft.public.access
Jörn Bosse[_3_]
external usenet poster
 
Posts: 20
Default One field, multiples entries

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
  #3  
Old June 3rd, 2010, 02:09 AM posted to microsoft.public.access
Access Developer
external usenet poster
 
Posts: 12
Default One field, multiples entries

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" wrote in
message ...
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



  #4  
Old June 3rd, 2010, 07:18 PM posted to microsoft.public.access
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default One field, multiples entries

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" wrote in
message ...
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



 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.