https://bugs.documentfoundation.org/show_bug.cgi?id=100167
--- Comment #10 from [email protected] ---
> Now add "cat"."cat" to the query. This query could be edited, because the
> primary keys of both tables will be content of the query.
No PK of either table should be required to edit the FKs of the intermediate
table. The query field "catdescr" depends on (cat.cat--<issue_cat.cat) which is
implemented in the WHERE clause. If cat.cat were editable from the subform,
wouldn't that expose it to accidental changes? Surely only the FKs are
required?
> 3. You don't need this SQL-Code for the subform. You would need the table
> "issue_cat" instead. From this table is only needed the field "cat". You have
> to change this field to a listfield. This field will show "catdescr" instead
> of "cat". So you could see the description and save the primary key.
But it is a valid approach. Also, isn't issue_cat.issue required to implement
the relationship between form and subform?
I have set issue_cat.cat and issue_cat.issue as PKs, and recreated the subform
and table control but it still isn't working on Ubuntu - going to try on
something else (Fedora or OpenSuse) when I have time later.
Thanks again.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
