Muliple Entries in Access 07 fields

  • Thread starter Thread starter Tara Metzger
  • Start date Start date
Actually, it wasn't possible in previous versions of Access (unless you're
talking about typing a delimiter-separated list into a text field)

I still don't it's a good idea, because it's much harder to query and work
with. Using the "proper" three-table design (which is what Microsoft is
doing under the covers) is still better. Unfortunately, Microsoft has not
seen fit to reveal the hidden tables they're using to store the data.
 
Doug,

Thank you. I agree with you it's not a good idea, but have used them in the past and was wondering if they were going to be a problem. Looks like they are.



Douglas J. Steele wrote:

Actually, it was not possible in previous versions of Access (unless you
19-Jan-10

Actually, it was not possible in previous versions of Access (unless you are
talking about typing a delimiter-separated list into a text field)

I still do not it is a good idea, because it is much harder to query and work
with. Using the "proper" three-table design (which is what Microsoft is
doing under the covers) is still better. Unfortunately, Microsoft has not
seen fit to reveal the hidden tables they are using to store the data.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Book Review: Silverlight 2 In Action [Manning]
http://www.eggheadcafe.com/tutorial...e23-b99338b59ee1/book-review-silverlight.aspx
 
Back
Top