Hello,
I am having some problem regarding the way the options in a lookup field is displayed. Currently the options are displayed numerically instead of displaying the actual text.
I have three tables which are ContactPersonnelT, OrganizationT and TrainingDonorT.
One of the fields in the ContactPersonnelT table is, ‘Affiliation’. This field is a lookup value (look up wizard) which comes from the OrganizationT table field, ‘OrganizationName’.
In the TrainingDonorT table I have a field called, ‘ContactPersonnel’. This field is a lookup value which comes from the ContactPersonnelT table field, ‘ContactPersonName’. In the drop down list of the ‘ContactPersonnel’, besides the ‘ContactPersonName’ I also want to display the ‘Affiliation’ field. However, instead of displaying the text in the ‘OrganizationName’ field, a numerical value is showing.
It will be very kind of you if you assist me by showing how to change the display to text instead of the numerical value. Thank you very much.
I am having some problem regarding the way the options in a lookup field is displayed. Currently the options are displayed numerically instead of displaying the actual text.
I have three tables which are ContactPersonnelT, OrganizationT and TrainingDonorT.
One of the fields in the ContactPersonnelT table is, ‘Affiliation’. This field is a lookup value (look up wizard) which comes from the OrganizationT table field, ‘OrganizationName’.
In the TrainingDonorT table I have a field called, ‘ContactPersonnel’. This field is a lookup value which comes from the ContactPersonnelT table field, ‘ContactPersonName’. In the drop down list of the ‘ContactPersonnel’, besides the ‘ContactPersonName’ I also want to display the ‘Affiliation’ field. However, instead of displaying the text in the ‘OrganizationName’ field, a numerical value is showing.
It will be very kind of you if you assist me by showing how to change the display to text instead of the numerical value. Thank you very much.