Sorting searched for data by field (data type)

Need help Database
1

Hi

Trying to sort a search for data by a field defined as a data type but selection is not available.

I have a field called project-status defined as another data type also called Project-status

I managed to fudge it earlier when I had project-status as a text field but really need it as a data type as is used in drop-downs and radio buttons

image
image1558×1296 251 KB

image
image718×1050 57.7 KB

image
image684×636 26 KB

Thanks in advance

2

Try “the other way around”. In the data source: Search for Project-status's projects: sorted by created date. In the search for Project-status you set up the sorting you want .

3

Genius. Thanks so much for your help.
Cheers
Ian