Drop Down with other details in Suggested Values

[jaichith]

Hi friends,

I am struck with an issue.

I have used an expression in Consignment Table (Child Table) Sort(select(Orders [Order SL NO], true)true)

By using above expression I am getting drop down in descending order.  I want them in deck view with multiple details like date, SL.no , customer name etc. 

How to achieve this?

Note :

1.Table Order is parent and Order SL .No is the key and label of the  table Order.

2. I don't have image in table. 

My expectation :

 

Where I am in :

 

@Suvrutt_Gurjar @dbaum 

[WillowMobileSys]

---

@jaichith wrote:

By using above expression I am getting drop down in descending order.  I want them in deck view with multiple details like date, SL.no , customer name etc. 

How to achieve this?

---

If I understand correctly, you wish to see several columns of values together in the dropdown.

The way to do this is to create a separate label column that CONCATENATES the values together in the way you wish - e.g.  "Column 1 Value - Column 2 Value - Column 3 Value".  Then set this new column as the Label for the table.  Do this in the SOURCE table for the dropdown.

[jaichith]

Thanks, any other method available? Like deck view ?

[jaichith]

Is this Virtual Column? 

[WillowMobileSys]

---

@jaichith wrote:

Thanks, any other method available? Like deck view ?

---

If you mean as a way to format a list of dropdown values, then no.  

---

@jaichith wrote:

Is this Virtual Column? 

---

It can be either a normal column or a Virtual Column.   I use a normal column to create the Label if all values are from within the table.  This helps lighten the burden on Sync times.

However, if the label needs to include values for OTHER tables, then I use a Virtual Column.  That way if that OTHER table changes, my Labels will be automatically updated with no additional effort.