How make all relation active between tables?

[Satish_Kumar]

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.

[Baskar]

Cool Dude.

Here in your model the prob is Bi-Directional , It will cretae ambiguity  between that tables so u can't .

Remove the both direction between unwanted places.

Let me know if any help

[Satish_Kumar]

@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]

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]

@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]

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 ?

[Satish_Kumar]

@Baskar

This Showing error.

[Baskar]

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"