Jump to content

Simple List - Dynamic SQL


Recommended Posts

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

 

  • Like 1
Link to comment
Share on other sites

  • 5 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...