How to display two fields in a combobox from a relation between tables

(0) Share

Report

Posted on by mimi51340

Hello,

I created two tables as below (TRI_NettingCorrelationAP and TRI_HFMCode). The aim is to get the HFMCode in TRI_NettingCorrelationTable from TRI_HFMCode Table.

I created a relation between these two tables.

I created a form where I get the combobox:

But how can I get a second column in the combobox from TRI_HFMCode table ?

Thanks a lot

All responses (6)

Answers (1)

mimi51340 50 on at

Like (0)

Report

RE: How to display two fields in a combobox from a relation between tables

Thanks now it works !
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: How to display two fields in a combobox from a relation between tables

Hi mimi,

Do you have the Title fields set in the properties for table TRI_HFMCode?
mimi51340 50 on at

Like (0)

Report

RE: How to display two fields in a combobox from a relation between tables

Perfect it works !

Last question, when I mouse over the TRI_HFMCode field, how do I display the description from the table? That is, the TRI_HFMDescription field.

Thanks
Verified answer

Community Member on at

Like (0)

Report

RE: How to display two fields in a combobox from a relation between tables

in this table TRI_HFMCode under field group (autolookup)
mimi51340 50 on at

Like (0)

Report

RE: How to display two fields in a combobox from a relation between tables

Where I need to do this ?
Community Member on at

Like (0)

Report

RE: How to display two fields in a combobox from a relation between tables

did you try to add the required fields in AutoLookup field group and check?