June 16, 200520 yr I have a field with Field Format set to "Pop-Up Menu" and a Value List Selected. In Browse mode I want a particular item from the Value list to be displayed as the "default" value. I've tried several approaches, but the only one that seems to work is using a script with "Set Field" and setting the value. Is there a "better" or more general way to select which Value List item is the default that the list will display? (Pop-up Menu or List, doesn't make a difference.) TIA.
June 16, 200520 yr If you are referring to the value that displays when a new record is created, use an auto-enter value for the field.
June 16, 200520 yr Author If you are referring to the value that displays when a new record is created, use an auto-enter value for the field. Nope... I am using the VL to set a global field. There is a button that runs a script that uses this global field to sort by whatever criteria the user selected. At startup the VL field on the layout in Browse mode is "blank", once I select a value from the list, it seems to be sticky (same value is displayed on every layout where the field/VL appears). It would be nice if the Define VL menu would let you define the "default" value.
June 16, 200520 yr If you are setting a global, then yes, it is supposed to maintain the same value for every record in the table and in any other tables in which it may be displayed. If you want to default the global on startup, just add a step to your startup script to Set Field [global; "default value"]. I disagree that a default value for a value list would always be nice, simply because the same list can be used for multiple fields, and you would not always want the same default for each field. But that is just my opinion.
June 16, 200520 yr Author If you are setting a global, then yes, it is supposed to maintain the same value for every record in the table and in any other tables in which it may be displayed. If you want to default the global on startup, just add a step to your startup script to Set Field [global; "default value"]. Ok... That's how I was doing it with a "Set Field" script step. I disagree that a default value for a value list would always be nice, simply because the same list can be used for multiple fields, and you would not always want the same default for each field. But that is just my opinion. Good point, maybe the place to put the "default" would be in the "Field Format" menu, where you specify which VL to use. Thanks.
Create an account or sign in to comment