Administration Features and Functions > Configuring Menus, Programs, and Workspaces > Configuring Lookups for Multiple Return Values
  
Configuring Lookups for Multiple Return Values
The majority of field lookups in Character mode return one value to the calling field. However a number of fields return values to several screen fields. You can now provide this functionality for QAD .NET UI screens.
This can be accomplished by editing the lookupreturnfields.xml file, which is stored in tomcat/webapps/<appname>/net/lookups/.
The format of each entry is as follows:
<program name="<program name>" screenid="<frame:field>" lookupfield="<lookup field>">
<returnvalue screenfield="<screen field>" fieldinlookup="<field in lookup>"/>
</program>
<program name> is the menu-level program name.
<frame:field> is a combination (separated by a colon) of the frame name and the first enabled field on that frame.
<lookup field> is the name of the field that the lookup is attached to. Use Ctrl+F to view the name of the field.
<screen field> is the name of the field that the lookup should return data to. Use Ctrl+F to view the name of the field.
<field in lookup> is the field in the lookup that the data will be returned from. It can be determined by running the lookup, right-clicking on the column of the data you are interested in returning, and selecting Properties.
If you require more than one additional return value, add another <returnvalue> element with the appropriate attributes.
Once you have added your data into the XML document, save it, close down the QAD .NET UI, and then restart the application.
The lookupreturnfields.xml file contains a number of examples of the above format.
If the QAD .NET UI version is 2.8 or greater running on QAD Enterprise Applications SE SP10 and above or QAD Enterprise Applications EE SP5 and above, you can also enable this feature using Drill-Down/Lookup Maintenance (36.4.8.1), which has additional fields that provide this functionality.
Program Message Color and Font Options
You can specify the color and font of program messages by setting the Message Color and Message Font options available in Tools|Options. Note that Message Color and Message Font apply to the messages automatically displayed by programs. (Message Color and Message Font options do not apply to workflow messages: these settings apply only to program messages.)