In general, it wouldn't be advisable to change either the
TitleField properties, or the indexes, purely to change what is displayed on a
lookup form. Luckily, Axapta gives us as easier way to achieve the same goal.
If the AutoLookup field group on the base data table has been
filled, then those fields will be used irrespective of the usual logic.
Modifying this field group is the easiest way to change which fields appear in
lookups against that table.
Bear in mind that while you
can add display and edit methods to your AutoLookup field group, the values
will not display correctly unless all required fields for calculations are also
included in the field group. For example, if you want to show the name of a
vendor, based on the VendAccount stored on a record, then the VendAccount
itself must also be included in the group. This is because the lookup query
only fetches the fields from the database which are actually to be displayed,
rather than the entire record.
No comments:
Post a Comment