Forum Discussion

Colinu's avatar
Colinu
Helper I
8 years ago

Relationships

I have two tables that i need to create a relationship between. Unfortunately the column (Submission ID) in one for the tables has duplicate numbers.

 

is there a way of creating a relationship?

 

I had thought of extracting the duplicate ID's to another tablebut this will take forever withthe amount of data i have. 

 

Tables

 

 

Need Help

2 Replies

  • Hardik's avatar
    Hardik
    Continued Contributor
    8 years ago

    Search for a column that is unique or create a composite primary key 

    • Colinu's avatar
      Colinu
      Helper I
      8 years ago

      Thanks for that but i have no column that are unique that could link the tables. 

       

      If i created a primary key how would i get the relationship to know what records are connected. 

       

      In the first table there is one parent field and in the second i have 2-6 child records. I need to link these. 

       

      Is there a simple way of extracting the child records into a standalone table?