Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Multiple Records in one Field (https://www.askmehelpdesk.com/showthread.php?t=362696)

  • Jun 8, 2009, 08:31 AM
    mcleyn
    Multiple Records in one Field
    HI!
    I would like to save up to 5 records in one field. What is the best way to do so?
  • Jun 8, 2009, 01:20 PM
    ScottGem

    There is none. This violates normalization rules and is very much a no no. If you need to attach multiple records or values to a field, you do so with a child table.
  • Jun 9, 2009, 07:16 AM
    mcleyn
    Quote:

    Originally Posted by ScottGem View Post
    There is none. This violates normalization rules and is very much a no no. If you need to attach multiple records or values to a field, you do so with a child table.

    Thank you.

  • All times are GMT -7. The time now is 01:05 AM.