How to allow a Reference Field to search by both Number and ID from the referenced table?
Hi everyone,I have a requirement where a field in my table is referencing another table (Reference field).In the referenced table, there are two fields:NumberIDMy requirement is:If the user types or searches using Number, it should display/select the...