I have a number of campaigns that are "Inactive" for that reason I want to prevent them from appearing in an sqs list when filling out a new record.

I thought of marking those Campaigns as deleted, which will take them off the sqs, but then they disappear altogether and are not visible on old records either, yet I need that history to remain visible.

I suppose I could do a check before saving and pop an exception notice if the campaign is inactive but that's frustrating to the user, I can just hear them: "beeep! why did you let me choose it in the first place?"

So, can the sqs be customized to not allow selection of Inactive campaigns?

thanks,
Francesca