select a field from dropdown lookup but use recId field as filter for the second custom lookup


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?



Hi Lakshmi,
if I got your issue correctly, user can select a non unique value from the first dropdown? So could be that in the same list you can have multiple option for same “name field”? If so, I think you should re-design it, because how can user choose one value among different options if they are all the same?