I need to create manual cases where 'case type' is 'Manual' I have 6 lookup fields on Case as
- Lookup_MTO (object is MTO)
- Lookup_Re (object is Re)
- Lookup_ToP (object is ToP)
- Lookup_Bk (object is Bk)
- Lookup_To (object is To)
- Lookup_Ld (object is Ld)
My requirement is If Lookup_To is populated by User on the New case UI, only Lookup_MTO related to that Lookup_To should appear as available options on Lookup_To field. Same with Lookup_Re , Lookup_ToP , Lookup_Bk and Lookup_Ld. Likewise user can populate any lookup filed not only Lookup_To ,in any case rest of the lookups should come up with values related to that Lookup field populated by user.
Relationship between objects is :
- Re(child) is having Lookup to MTO(parent)
- To,ToP,Bk,Ld is having many to many relationship with MTO
- Bk is child to ToP (look up relationship)
- To is a child to ToP (look up relationship)
How can we achieve this ?