Apex Code Development You need to sign in to do that
Don't have an account?
Amol Ch Look up filter not able to configure
I,ve one Parent object 'Patient' and Child Object 'Patient Services' and another Parent object 'Job'
On Patient Services Object one Look up field Named Patient related to Patient object & another lookup field Named job related to job object
The Location Field on both object Patient and Job.
When adding a Patient Service from the Patient object; then the Job field lookup should filter based on the Location of the Patient.
When I click on Job lookup field icon, it allow to show me only record that has location field is equal to location field of Patient record Patient 000972 in above image.
How to configure in look filter Please help
On Patient Services Object one Look up field Named Patient related to Patient object & another lookup field Named job related to job object
The Location Field on both object Patient and Job.
When adding a Patient Service from the Patient object; then the Job field lookup should filter based on the Location of the Patient.
When I click on Job lookup field icon, it allow to show me only record that has location field is equal to location field of Patient record Patient 000972 in above image.
How to configure in look filter Please help
Can you provide more information about your data model?
When click on job look up field icon ,I have to filter the same location related record. location field present in Patient object Their are more than one record of same location not a single record. when we use filter for realated record then we can select manually one record from them.
In this Location is also another object.
Let's say, you are creating a record of PatientService which is PatientService1 and it's parent record is Patient1.
Now Job should be populated/auto-filled with Job Name/Id where Job record's location == Patient record's location.
Let me know if is this you want.
Suppose I am are creating a record of PatientService which is PatientService1 and it's parent record is Patient1
Now when I click on Job field look up icon it allow to show me all related Job Record. conditon Job Record:Location == Patient record's location.
When It show me related job record in look up filter then I select one of the record from them manually.
It would show me multiple record as shown in above image then i will select one record manually.