Hi juror58, I don't know much about databases particullary Alpha 5 and I'm just starting to learn FileMaker. From your paragraph above second to the last where you would want the text to be converted to uppercase, proper, etc., FileMaker has a text function for that and these are: Proper, Upper, and Lower. You can use those text functions in a script and set it up as one of your object's (your text field) script trigger like "on object modify" or "on object exit" .
 For your "logical" field make it of type Number. Define a custom value list of a single value, 1. Format your number field as a check box field and select this value list as the value list to get a single check box in the field. resize the field so that the 1 is hidden and only the check box is visible.
 if you want text to always be defined to show a specific text style, you can enter layout mode and use either the formatting tool bar or the inspector's appearance tab to specify a text style. But this style setting can be superceded by text formats applied directly to the text in the field or that was pasted into the field along with the text if you copy and paste text into the field from another source.
In such cases, you may want to define an auto-entered calculation: TextFormatRemove (self) and clear the "do not replace existing value" check box to ensure that the layout specified formatting will control the appearance of the text in the field.