How does Axapta determine which fields to use?
Axapta uses a simple system to determine which fields to display in an automatically created lookup. If no special changes are made, then the fields shown on the lookup are determined by the following information from the base table: • The field(s) responsible for the relation (in the order of the content of the relation-treenode of the table or the extended datatype) • TitleField1 • TitleField2 • The first field of every index of the table (in the order of the index-id) A maximum of six fields will be shown, and duplicates will be removed.