https://bugs.freedesktop.org/show_bug.cgi?id=79861
Priority: medium
Bug ID: 79861
Assignee: [email protected]
Summary: Foreign keys a.k.a Master / Slave fields are ignored
in Form with subform.
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.3.0.0.beta2
Component: Database
Product: LibreOffice
Created attachment 100781
--> https://bugs.freedesktop.org/attachment.cgi?id=100781&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
