Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Unique Index

Discussion in 'Information Technology' started by Donbenz, Jul 28, 2006.

Tags:
  1. Donbenz

    Donbenz
    Expand Collapse
    Guest

    I am trying to set up a relationship for three tables. I want the
    information from two of the tables to be stored in the third. When I set up
    the relationship for the fields I want stored it gives me an error message
    that says "No unique index found for the referenced field of the primary
    table." I have a primary key set up in all three tables. I have also tried
    making all the fields unique. If anyone has any ideas i would appreciate the
    help.

    Thanks,

    Donbenz
     
  2. Loading...

    Similar Threads Forum Date
    India Gwalior: A Unique Link to India's History Breaking News Nov 16, 2013
    Heritage Sikh Art: Reflections Of A Unique Spiritual, Secular Sikhism Identity History of Sikhism Jan 9, 2013
    General Great Sindhi Folk, wonderfully unique music style: 1 Videos Feb 23, 2012
    Mother Hope: Prakash Kaur and her Unique Home for Girls Inspirational Stories Feb 1, 2011
    In US, Sikhs succeed in push for understanding their unique culture Interfaith Dialogues Jun 18, 2010

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Hi Donbenz

    Best idea would be to not do what you are trying to do.

    Set the primary key for each table and use this to link (child) to the 3rd
    (parent) table.

    To have the same data stored in 2 table is simply not the idea of a
    relational database. If you can (it's not "always" possible but most of the
    time it is) to store only data that is unique ineach record.

    As an example -
    Name = John (Is unique even though there are many Johns as it refers
    specifically to "this" john)
    Shoe color = Red (this is NOT unique as many people will have the same color
    shoes)

    It's a bit more complex than that but hope you get the idea.

    Press F1 and serch on "Create a relationship between tables"




    --
    Wayne
    Manchester, England.



    "Donbenz" wrote:

    > I am trying to set up a relationship for three tables. I want the
    > information from two of the tables to be stored in the third. When I set up
    > the relationship for the fields I want stored it gives me an error message
    > that says "No unique index found for the referenced field of the primary
    > table." I have a primary key set up in all three tables. I have also tried
    > making all the fields unique. If anyone has any ideas i would appreciate the
    > help.
    >
    > Thanks,
    >
    > Donbenz
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page