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