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
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 ?

      • Baskar's avatar
        Baskar
        Resident Rockstar
        9 years ago

        Can u please share your data i will help u.

         

        1. change relation ship both to single .

         

         

         

        2. change 1 on "Trident" and * on " Summary "

         

        do the same in "Trident " and " Payment "

         

        after create the new relationship on "Payment and summary"