https://bugs.freedesktop.org/show_bug.cgi?id=72696
Priority: medium
Bug ID: 72696
Assignee: [email protected]
Summary: Other: primary-foreign key pair relationship
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA PossibleRegression
Status: UNCONFIRMED
Version: 4.2.0.0.beta2
Component: Database
Product: LibreOffice
Created attachment 90748
--> https://bugs.freedesktop.org/attachment.cgi?id=90748&action=edit
a database created with 4.2 Beta2 that shows the problem
Problem description:
Table A has a foreign key linked to the primary key of Table B. Table B has a
foreign key linked to the primary key of Table C. After a form is created and
data is entered, the form is opened. When records are changed in the main form,
there is no change in the data in the sub form.
Steps to reproduce:
1. Create Table A with a primary key, some fields, and a foreign key.
2. Create Table B with a primary key, some fields, and a foreign key.
3. Create Table C with a primary key.
4. Using Tools > Relationships, click the New Relations icon. Place
Table A and its foreign key on the left side of the dialog and Table
B and its primary key on the right side.
5. Select No Action as the option for both the Update and Delete
options. Click OK to close the option.
6. Follow steps 4 and 5 to define the relationship between Table B and
Table C.
7. Save the relationship, and save the database.
8. Create a form with a main form (Table B) and sub form (Table A).
9. If using Design View to create the form, create the second sub form
containing Table C. Use the Form icon to define the two
relationships. Save the form, and save the database.
10. Enter data into the form: into the main form and both sub forms so
that you have three or four records.
11. Use the form navigation toolbar to change the record that is visible.
Current behavior
When the record is changed in the main form (Table B), records are not
changed in the sub form (Table A). Changing the active record in the sub form
(Table B) does not change the records visible in the other sub form (Table C).
Expected behavior:
When a record is changed in the main form (Table B), the visible records of
the sub form (Table A) change to the ones that relate to the new record of the
main form.
Operating System: Debian
Version: 4.2.0.0.beta2
Last worked in: 4.1.3.2 release
--
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
