So, I've created a custom System Table which references another table, in this case T_CAMPAIGN, to allow the user to select campaigns. The problem is, for the purposes of this table, I want to be able to select all sorts of historical campaigns. But when I try to select an old campaign on the list (one which is shown in grey as inactive), it gives me an error "You have selected an inactive row. Please make another selection." That seems unfair, if you aren't going to let me select it, just don't show it! I've set up plenty of dropdowns where I wanted that and simply included "inactive <> 'Y'" for the dddw_where column.
Is there some configuration I'm missing here to allow this? I suppose perhaps a view that didn't have an inactive column would get around this...
> I suppose perhaps a view that didn't have an inactive column
I think that's your best/simplest bet.
Thanks, yeah, that's way I've done. Weird decision, since that's not the way it works anywhere else in the interface...
> Weird decision, since that's not the way it works anywhere else in the interface...
I can imagine someone didn't want inactive system table records to be selectable, though it would be nice if the client would offer to re-activate if an inactive record is chosen. I'm not a fan of the numerous one-choice, must-be-dismissed popups the client has.