Forum Discussion

scottfvt's avatar
scottfvt
New Contributor
14 years ago

Choice List (Based on SQL) in Requirements from Contacts

I would like to have a Custom Field in my Requirements record with the Field Type "Choice List (Based on SQL)"  The choice list would be formed from Contact Management.  From the Data Dictionary docum...
smiller257_1's avatar
smiller257_1
Contributor
14 years ago

I think the SQL you would need is:



SELECT DISTINCT Custom1 + '-' + CompanyName as CompanyNumber

FROM Contacts

WHERE ProjId = &ProjId

ORDER BY 1



The ProjId = &ProjId would limit it to the contacts in the current project.

The ORDER BY 1 will sort it by the Custom1 concatinated with the CompanyName.



Hope that helps.