Created attachment 58054 [details] Database example with 2 forms showing both bugs Problem description: It's a combination of 2 related problems. A. Selecting a field from a combo box changes to display the value column instead of the human-readable label (the one that the user clicks). B. Additionally, if the label is calculated (instead of just a plain field), whatever you select the value will be always zero. Steps to reproduce: A.1. Open attached file A.2. Open the form called "addresses-bad" A.3. Add a new record picking something from the "zone" combo box. B.1. Open attached file B.2. Open the form called "addresses-worse" B.3. Add a new record picking something from the "zone" combo box. Current behavior: A. After adding the record, the text "City X" changes to a number (its ID). B. After adding the record, the text "City X" changes to 0. Expected behavior: A. The combo box field shows the label, not the value. B. Like A but also the value should be correct. Platform (if different from the browser): Tested under Linux and Windows LibreOffice Base. Browser: Mozilla/5.0 (Windows NT 5.2; rv:10.0.2) Gecko/20100101 Firefox/10.0.2
Thanks for bugreport reproduced in 3.5.3 on Fedora 64 bit in 3.3.4 on Fedora forms not working correctly, impossible to verify in 3.5.2 on Windows 7 not working because JRE not installed (on my comp)
Created attachment 63984 [details] Corrected fields from combobox to listfields You have choosen the wrong field for it. A combobox shows the values of the table of the form. You could change these Values. You can't put a text into a numberfield. You look for a listfield. There you could choose the names and put the primary-keys of the names into the table of the form. Open the forms and you don't see any bug. Open the forms for editing and have a look at the fields with a click of the right mouse-key. Choose column → data. You could see the SQL-code and then the number of the bounded field (1). Numbers of the filed begin with 0, so the second field in the SQL-code is the field that is saved in the datafield "zone". The first field is shown to the user of the form.