Creating (none) on a dropdown

The easiest way is just to do a UNION in the SQL query as such:

Select description, inactive, id

From dbo.TR_CONT_DESIGNATION

UNION

SELECT '(none)','N', NULL

+Ryan Creps

+Tessitura Network

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matthew Hodge
Sent: Wednesday, February 08, 2012 1:09 AM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Creating (none) on a dropdown

Quick question - if I'm creating a custom tab in Infomaker, I understand how to make a dropdown by linking to another Infomaker object that contains the dropdown options. But how do you get (none) to be one of those options?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

The easiest way is just to do a UNION in the SQL query as such:

Select description, inactive, id

From dbo.TR_CONT_DESIGNATION

UNION

SELECT '(none)','N', NULL

+Ryan Creps

+Tessitura Network

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matthew Hodge
Sent: Wednesday, February 08, 2012 1:09 AM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Creating (none) on a dropdown

Quick question - if I'm creating a custom tab in Infomaker, I understand how to make a dropdown by linking to another Infomaker object that contains the dropdown options. But how do you get (none) to be one of those options?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!