function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sfdc_beginner7sfdc_beginner7 

Manual case creation with validation on 6 lookup fields

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 ?