a better data type(access)

Results 1 to 3 of 3

Thread: a better data type(access)

  1. #1
    Neils Guest

    Default a better data type(access)

    Hello,<BR><BR>I&#039;m working on an online ordering system. One of my tables contains all the orders taken. When someone orders more than one item, I simply store a comma delimited list of product numbers into a column called &#039;products&#039;, and a similar list of quantities into a column called &#039;quantity&#039;. <BR><BR>I&#039;m wondering if there is a better way to do this in Access. Is there some data type that is specifically suited to store a list of items like this, and is perhaps a little easier to work with??<BR><BR>Any help is appreciated.<BR><BR>Neils

  2. #2
    Join Date
    Dec 1969

    Default Learn about NORMALIZATION

    If you are designing databases and don&#039;t know about normalization, then you are heading to a *disastrous* fall.<BR><BR>Get a good beginning db design book and read, read, read!<BR><BR>For a *summary* of the ideas, see here:<BR>http://w3.one.net/~jhoffman/sqltut.htm<BR><BR>But you really, really, really need to go get a book. Or, at a minimum, look up the topic online at several places.<BR><BR>

  3. #3
    Neils Guest

    Default RE: Learn about NORMALIZATION

    As always Bill, I thank you for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts