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.
Use a combobox rather than a dropdown. Click Fields - Edit and select a layout. Refer to picture.
>>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.<<
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.
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.
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.