Need Solution for key

Discussion in 'Databases' started by optiplex, Apr 11, 2011.

  1. #1
    Hello

    I face this problem and my thinking is that after sharing our problem. You will provide me a good suggestion.

    I create relationship between 3 tables with 1 primary key.

    I share our problem with attachment.

    tables relation's does work correctly.
     

    Attached Files:

    optiplex, Apr 11, 2011 IP
  2. Amator

    Amator Well-Known Member

    Messages:
    1,424
    Likes Received:
    55
    Best Answers:
    0
    Trophy Points:
    165
    #2
    Please provide more information.
    What data do you (want to) keep in the database / tables
    Please provide some examples and let us know what exactly the problem is with the relations
     
    Amator, Apr 11, 2011 IP
  3. randheer

    randheer Greenhorn

    Messages:
    19
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #3
    After seeing your tables its look like
    Table1
    Table2
    should be the msater table and both have there primary key....
    Table2_1 should contain forign key for the both i.e relation between the both primary keyss.....
     
    randheer, Apr 12, 2011 IP
  4. welkin

    welkin Active Member

    Messages:
    521
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    58
    #4
    From the information you've provided, it doesn't seem you have a problem. If you want an answer for a problem, it would be good if you write what your problem is...
     
    welkin, Apr 12, 2011 IP
  5. EitanXOR

    EitanXOR Greenhorn

    Messages:
    30
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #5
    I also don't quite understand what's the problem exactly. You pretty much just described your database structure and nothing else... provide much information if you want help.
     
    EitanXOR, Apr 16, 2011 IP