Forum Discussion

Satish_Kumar's avatar
Satish_Kumar
Helper V
9 years ago

How make all relation active between tables?

Hi All, I am facing a program while using column of one table in the other table because the two table donot have active relationship.     How to make all relationship active.
Need Help
Satish_Kumar's avatar
Satish_Kumar
Helper V
9 years ago

Baskar

this error it is showing me .

and i need one column from this table to my new table so need the active relationship badly.

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

u r wrong. 

 

Cool dude, first understand the existing relationship between these tables .

 

 

 

U already have relation ship between these twao table. then how another realtion ship work ?

So u can't , if want that relationship u have to remove "Trident Info systems Live" and "Payment Date".

 

  • Satish_Kumar's avatar
    Satish_Kumar
    Helper V
    9 years ago

    Baskar

    If i remove the relationship then the calculated column field will show error which i donot want at all.

    So if you have the alternative way then share please.

     

    Regards,

    Satish Kumar 

    • Baskar's avatar
      Baskar
      Resident Rockstar
      9 years ago

      Cool,

       

       1. Change the relatioship between "Trident info"  and "Summarize" to 1 to many (1:*)

        2. Then create new relationship on "Payment" and "Summarize" , that should be (1:*)

       

      Try this let me know what happening there ?