GabrielV Posted January 24, 2008 Share Posted January 24, 2008 I have a database that keeps track of certain actions, if completed YES is selected in the YES/NO option field. How can I let FM let me know which records actions have NO value? Quote Link to comment Share on other sites More sharing options...
mfif Posted January 24, 2008 Share Posted January 24, 2008 Use a radio button field instead of a checkbox, and show both YES and NO. If both are blank... But if you need to do a search I guess you'll need a regular field to search on, unless the search is scripted. Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted January 25, 2008 Share Posted January 25, 2008 Actually if you copy a value to the clipboard (including the = sign to represent "empty") and then in Find Mode* click onto a checkbox or radiobutton formatted field and paste, you can thereby enter strings other than those provided by the value list. You still might want a regular field somewhere, since that's a bit of a cumbersome workabound. * or Browse Mode for that matter, as some developers have eventually discovered to their dismay Quote Link to comment Share on other sites More sharing options...
mfif Posted January 25, 2008 Share Posted January 25, 2008 As a result of being in this forum I am getting really persnickety about data validation these days. Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.