I'm trying to create a new UI for a request form. I'm trying to have specific UI components default to specific values. I don't understand how the "default values" options work. I can see several places I can declare a default value: Sql Tables, IDO Properties, and in WinStudio Design Mode.
Right now, I have two drop lists I'm trying to work with: one is based off of the warehouse list and the second is based off of a user defined type (for status).
- If I define the default value at the SQL level, I never see it and WinStudio complains if I try to save a record without a value.
- If I define the default value at the IDO level, it's completely random if I see it show up. Sometimes it gets set, others its blank.
- If I define the default at the Form level, I never see it.
Where are these defaults supposed to be defined so they actually work? 9.01.12 on premise. I can't tell if I'm making mistakes or if the toolset is faulty.