unable to sort a prompt table view for a non-key field
vendor_id -key
descr
I need to use this view as a prompt table on a field and the prompt view should sort by descr in ascending order which is not a key field on prompt view table.
Tried the sql behind it making it ascending order. But the ascending or descending just depends on record field properties on a key field which executes from the page.
Any ideas?