Legacy - Displaying Column Headings in Advanced Lookup

The default display for the data shown in an Advanced Lookup control is as follows:

Column headings can be displayed in the grid by using the following code:

Code Breakdown

Select '<b>CompanyName</b>' as Column1, '<b>Telephone Number</b>' as Column2

This code allows users to name the column headings as they wish (so in this example, CompanyName and Telephone Number will appear as column headings). as Column1 will appear when at the final stage of mapping data, so can be named to make the mapping process easier if required:

Union

The union command joins the column names to the grid of data returned and displayed.

Select [CompanyName],[Telephone Number] from [Plumbers]

A standard search query can be used to determine what data is retrieved and displayed.

Note that the test value screen will not display any options:

The result from this example is:

Note: to prevent the column headings being selectable the following code in a Calculate control will hide the tick box:

Adv = getCSObject([Control Name]).name.replace('F','ifAL');

trs = eval('window.frames.' + Adv + '.document.getElementsByTagName("td")');

trs[0].style.visibility = 'hidden'

trs[0] refers to the column number, 0 being the first one.