Muliple Entries in Access 07 fields

[Tara Metzger]

Hello,

I have a very basic question (I think). In previous versions of Access even though fields could be set up to accept multiple entries it was not recommended. Is that still the case? If so could you elaborate on what problems it could cause?

Thank you.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Professional XML for .NET Developers [WROX]
http://www.eggheadcafe.com/tutorial...73-55b070281e56/professional-xml-for-net.aspx

 

[Douglas J. Steele]

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.

 

[Tara Metzger]

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