Created attachment 100781 [details] Example embedded HSQL Database demonstrating the problem. Embedded HSQLDB (v1.8)Subform master/slave fields (i.e foreign keys) ignored under 4.3.0.0beta2 Ubuntu 14.04 64 bit. A regression from LO 4.2 1. open the form "FoodTypeFromTables". Note that the correct "type" field entry is present. 2. navigate to the next record. Expected behaviour: type field is updated to reflect the type of field. Observed behaviour: type field remains blank. The "food" table is joined to the "type" table by a foreign key. When the "food"."type_id" and "type"."id" fields are used in a subform to form a Master/Slave field relationship the "type" field in the "FoodTypeFromTables" is not updated when moving from record to record with the navigator arrows or typing a record number directly into the navigators record number field. This works under: LO Version: 4.2.5.1 Build ID: 881bb88abfe2992c6cede97c23e64a9885de87de. Fails under: Version: 4.3.0.0.beta2+ Build ID: d0930b170d11cd834b34b95202ebdc3e4a96182d Version: 4.4.0.0.alpha0+ Build ID: b92ef157ecb43f6afc0494fb32e586eef5ea017d
Hello, I reproduce with LO 4.3.0.0.beta2+ Build ID: 4b5975b1f777c85259bc38afbfae8e1160fbebbe TinderBox: Win-x86@42, Branch:libreoffice-4-3, Time: 2014-06-08_21:29:21 & Windows 7 Home Premium. Works with LO 4.2.4.2. Regards, Jacques
This seems to be a duplicate of Bug79427. After changing the filed in the mainform set the cursor in the subform. It will show row 2 of 1. Set this back to row 1 and you will see the right "type".
The first fix for bug 79427 was incorrect and didn't fix this. The revised fix does, so I'll count this as duplicate anyway... Thanks for giving me the second example which showed that my first try at fixing bug 79427 was not thorough enough! *** This bug has been marked as a duplicate of bug 79427 ***