cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LabDude
Level: Powered On

How to put a second field in a Drop down list as information for selecting the main field

Hi,

I have a Dropdown list that has the following against the Item: Sort(Distinct(Table,Field), Descending)

This allows me to populate a line graph and gallery based on the field selected.

What I would like to do, is have the ability to include a second field from the Table that helps with selecting the primary field. In this case the primary field is a vessel and I want the second field that tells me what is in that vessel.

 

Hope thats enough info.

Thanks

3 REPLIES 3
AndySid
Level 8

Re: How to put a second field in a Drop down list as information for selecting the main field

Hi,

Use a combobox rather than a dropdown. Click Fields - Edit and select a layout. Refer to picture.


Capture.PNG

 

>>If you found this reply helpful, please mark this as the answer to close the topic and make it easier to find for other people with similar questions.<<

LabDude
Level: Powered On

Re: How to put a second field in a Drop down list as information for selecting the main field

Sorry for the delay in replying.

While this option did work bringing up the second field for additional information, it grabbed all entries.

To explain better;

 

In the field 'Vessel', I will have multiple entries for the same vessel. So in this case, when I use the combobox, I will have to scroll through 10 different entries for one particular vessel, before I will see entries for the next vessel.

E.G.

Vessel 1

Batch#1

 

Vessel 1

Batch#1

 

Vessel 1

Batch#1

 

Vessel 2

Batch #4

 

So if I can make it so the combobox only gathers one entry for each vessel, this will make the selection side of things much easier.

 

Thanks

AndySid
Level 8

Re: How to put a second field in a Drop down list as information for selecting the main field

You are already using Distinct, so without seeing an example of your data one approuch maybe to have a dropdown for the vessel and then filter another dropdown on that.