You need to sign in to do that
Don't have an account?
Amr Mohsen
Filtering lookup field based on another one
Hello,
I've a schema called ESCALATION which has fields [Type, Subtype, EscalationTime] and acts as Many To many relationship between TYPE schema ans SUBTYPE schema, I created custom lookup field which contains all TYPE data in Cases page . I want to create another lookup field that displays SUBTYPE based on relationship.
If I represent it in SQL statement it will be : "SELECT SubType FROM ESCALATION WHERE Type = ' Types lookup field value'"
I've a schema called ESCALATION which has fields [Type, Subtype, EscalationTime] and acts as Many To many relationship between TYPE schema ans SUBTYPE schema, I created custom lookup field which contains all TYPE data in Cases page . I want to create another lookup field that displays SUBTYPE based on relationship.
If I represent it in SQL statement it will be : "SELECT SubType FROM ESCALATION WHERE Type = ' Types lookup field value'"
Is it possible to explain more about requirement and the actual objects relationship.
Regards,
Mahesh