I have a first lookup (leanschedulegroup table\name field). when the name is selected, the recId of the record must be used as a filter for the second lookup.
The problem is name field is not an unique identifier. So we cannot use find or any other static methods to retrieve recId of the LeanScheduleGroup table.
Could someone help me in guiding how to retrieve recId of leanScheduleGroup table in this particular scenario?