Show both "name" and "customer_number_c" in the SQS for Accounts

Question

I have changed our Accounts default filters to allow the users to enter a Name or Customer Number when linking an Account to other records in our SugarCRM via Relate Field (be it an actual relate field or one defined by a 1:M relationship). 
 When they search using the SQS they would like the SQS dropdown to display both Name AND Customer Number. 
 For example, when entering customer number 123 in the relate field's SQS it will pull up accounts with customer number 123 but also 1234 and the dropdown will display only the account names, and not the customer number. 
 Ideally they want to see both "Name CustomerNumber" or "Name (CustomerNumber)"... you get the idea. 
 Thanks, Francesca

Francesca Shiekh · Accepted Answer

I understand this functionality must work same quick search, i remember that section are a layout that content some views between theses "quicksearch-results" may be are help to you. 
 In other case i see the code of clients/base/fields/relate/relate.js and exists one function called search() into retrieve data from module and i want show yourself this code, the coments with this characters "<--" maybe give you a idea. 
 
 This is result

Cheers

Francesca Shiekh · Answer

Perhaps a different way of thinking about this, but could you: 
 
 Create a new text field called customer_name - copy the data from the current name field into it 
 Add the custom name field onto the record view layout so its editable by users 
 Make the core name field a calculated value and concatenate the customer number and name fields as Name (CustomerNumber) 
 Recalculate calculated values for all records via listview 
 
 Based on my understanding of your original post, this will match people based upon the customer number in its existing field, and the name which is still the start of the core name field - but as the full name field is now calculated, it will display that in all the expected places, including the type ahead dropdowns when setting relationships.