Simple List - Dynamic SQL

[Martyn Houghton]

Would it be possible to have a type of Simple List source for use in progressive capture questions and custom fields which uses a SQL query to generate the available options?

The reason for asking is that we are looking to log internal project management requests in the system, but they will relate to an external customer(contact) organisation. So rather than having to maintain a list of organisations in a simple list, I would, in this case, use a SQL query to obtain a list of organisations from the existing internal table where the industry type is a certain value.

Cheers

Martyn

 

[samwoo]

+1 for a feature like this (expanded to other places in the system as well as the above)

[Steve Giller]

+1 from me