Welcome to SPN

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

Sign Up Now!

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
     

Share This Page