Help with a reference qualifier

[jlaue]

Hello - 

I have added a field to the Company (core_company) table that is a reference field to the Vendor Contact (vm_vendor_contact) table.  I want this Vendor Contact reference field to only show the Vendor Contacts that are tied to that particular Company record.  

I have added the following reference qualifier, however it is not working the way I planned, it just displays all of the records in the Vendor Contacts table that have a value in the Company field.  If I remove the reference qualifier it then shows ALL the records in the Vendor Contacts table, so it is doing something, just not what I am expecting:

I do see that the records are making the relationship, as I have added a Vendor Contacts related list, which is working properly and showing the one test Vendor Contact that I would expect to see in my reference field based on the qualifier above.

When clicking on the lookup on the 'Tester Internal Vendor Contact' reference field, I would expect to just see the one contact that has that Company value in their record.  However, as mentioned earlier it is returning all vendor contacts that have any value in their Company field.

This is the only record I expected it to return:

Thanks for any help or guidance in advance !

[Muhammad Khan · Accepted solution]

Hi @jlaue 

Try this advanced reference qualifier.

javascript: '<backend_name_of_company_field_in_vendor_contact_table>=' + current.sys_id;

javascript: 'company=' + current.sys_id;

[jlaue]

Thank you so much!  That worked perfectly!