Results 1 to 2 of 2
  1. #1
    neo651 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    110

    Multiple Table Relationship Design


    I have a database with 17 different devices that have IP addresses. I want to manage these IPs with a single table. I want the table to display the IP Address and the device its associated to, but DeviceID are only unique within the tables. How do I create a reference that is unique to any device across all 17 devices?

    Thank you.

  2. #2
    goodguy is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Dec 2010
    Location
    Zanzibar, Tanzania
    Posts
    229
    Make one table called tblDevices with DeviceID as primary key.
    Make another table called tblIPAddresses with IPAddress as primary key.
    Make a third table called tblDeviceIPAddresses that has both PKs as FKs.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Conditional Table relationship?
    By srf.ucd in forum Database Design
    Replies: 1
    Last Post: 05-13-2011, 10:32 AM
  2. Table design to Track Multiple Client Types
    By TannerT in forum Database Design
    Replies: 6
    Last Post: 06-02-2010, 08:21 PM
  3. table design: one big table vs. multiple small tables
    By lstairs in forum Database Design
    Replies: 3
    Last Post: 12-31-2009, 08:46 AM
  4. Relationship Design
    By krymer in forum Database Design
    Replies: 3
    Last Post: 11-28-2008, 09:09 PM
  5. design using relationship...
    By dsnyder in forum Database Design
    Replies: 2
    Last Post: 10-21-2008, 12:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums