In our existing functionality we have two entities, say A and B with relationship as defined:
A (1) : B (N) ---> we use this to to show quick view of entity A on entity B's form.
A(N) : B(1)----> We use this to display a lookup of B on entity A's form.
Now, we want to be able to display a subgrid of B on A and A on B, for which i want to delete the existing relationships and create manual N:N relationship by creating a new entity C like: A(1):-> C (N) : <-B(1)
My question what should be the steps to create N:N relationship:
1) Shall i first create the new N:N relationship OR I have to first delete the existing functionality and relationship before.
2) What will be the impact on the exitsing process if i break the 1:N relationships, how can i assess the impact.
Any kind of pointers will be helpful.
Thanks,
PS
