Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Location
    Indiana, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple data? (Access 2000)

    I am attempting to track engineering changes in my company with an Access database. Often there are multiple part numbers changing on a single request (which is my key field). The part number is currently a single field that I hope to keep intact. Does anyone have suggestions how to best handle these situations?

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple data? (Access 2000)

    In order to keep this normalized, if there are multiple PartNumbers per Engineering Change Request, the PartNumbers should be held in a second table, along with any other request information specific to this part number. There is a one to many relationship between these tables.

Posting Permissions

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