Have a VERY simple form with a dropdown list on it.
1> Add process works great...not a problem.
2> Edit process works great as far as storing the selected or entered data.
3> On entering the Edit mode, the dropdown does not select the value in the list corresponding to the value stored in the database - yes...I am storing values not text and I have confirmed.
4>Did find a old post about an issue with XMOD not liking fixed character value fields and converted the database to use varchar instead. That fixed the problem in the simple test form created with form creator and I thought I was fine....BUT...
5> I found that if the edit process uses a stored procedure to UPDATE the database, the value is stored correctly in the database...but if you edit the record again, the dropdown list is broken. Replacing the SP with a submit command ="Update, etc" fixes the problem and the DDL works as it should.
I much prefer to work my database adds, edits, and deletes via SP where I have much more control. This is VERY strange behavior and these are just my preliminary findings...
Anyone?