How to get two columns to display in a reference field?

[gjz1]

In my company we have departments with multiple divisions in each department.   Many departments have the same division name, for example Administration is a division in all the departments.

I created a new division table with a reference field to Departments (cmn_department) and added the division reference field to the user table (sys_user) and form.   However, I need two columns, division and department in order to differentiate which division to select.   I have added attributes to the Division reference field but I'm still not getting Division and Department as columns, only Division.   What am I missing?

On the User form:

1.   I added Division as a reference field.

2.   I selected Configure Dictionary on the division field.

3.   In Advanced View I added ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_department,ref_ac_order_by=name to Attributes.

I have tried multiple variations of the attributes, none of it seems to work.

This is in Jakarta.

[gjz1]

Unfortunately I don't have Matt's complete response, but I do have the text from his email.

"Try this in the attributes section instead (replacing "department;id" with your field values): ref_auto_completer=AJAXTableCompleter,ref_ac_columns=department;id,ref_ac_columns_search=true

Then after clicking the Magnifying Glass on your new field, right click on one of the column headings and choose Configure > List Layout. I assume the Department column will already be there, but you should be able to add the Parent/Division field and remove any fields that are not required."

What fixed it for me was configuring the List Layout.  You have to click on the magnifying glass on the new field, then when the list appears click on one of the column headers and configure the list layout from there.  Hope this helps.