Description: when adding rows to my table components in a simple form; on columns that have a sql list dropdown defined such that i can select by uom_name and uom_id is returned then NULL is returned iof the same selection was made for this column on the previous row ( see error-base_bug_search_anomaly_06.png) Steps to Reproduce: 1.create new row in table components a. table_components_base_structure.png b. table_components_postgres.sql.png 2. component_id auto populates 3.enter a number for units 4.select the same uom_name from the dropdown list a. definition- base_bug_uom_id_control properties.png b. sql list- base_bug_uom_id_list contents.png c. base_bug_search_anomaly_03.png 5. tab to header_id and enter a header_id a. base_bug_search_anomaly_04.png 6. tab to ingredient_id and select and ingredient from the dropdown list a. base_bug_search_anomaly_05.png 7. create new row 8. get error message a. base_bug_search_anomaly_06.png Actual Results: null is returned to the uom_id column Expected Results: the uom_id that matches the selected uom_name should be returned Reproducible: Always User Profile Reset: No Additional Info: Version: 7.3.4.2 / LibreOffice Community Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5 CPU threads: 8; OS: Linux 5.18; UI render: default; VCL: gtk3 Locale: en-NZ (en_NZ.UTF-8); UI: en-US Calc: threaded
Created attachment 182141 [details] entered G to select the id for G form dropdown list - next uom_name displayed
Created attachment 182142 [details] force entry of 'G' from dropdown
Created attachment 182143 [details] tab to header_id column - uom_id entry disapears
Created attachment 182144 [details] enter an ingredient
Created attachment 182145 [details] create new row and get error message
Created attachment 182146 [details] sql definition for tablke components in source postgresql db
Created attachment 182147 [details] table definition for uom in source postgresql database
context - base is acting a client db of the postgresql source database
Have tried this: PostgreSQL with direct connection, 2 tables. Primary key from table2 is foreign key from table1. Created some content in table2 for getting content for a listbox. Created a form with table1 and a listbox, content from table 2. Created it as tablecontrol, as I could see in the screenshots. When adding new data in the form I could choose every value of the listbox. I could choose the same value as it is choosen the row before. There won't be added NULL instead of this value. Might be it is a special bug together with gtk3… System here: Version: 7.4.6.2 / LibreOffice Community Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded