[Libreoffice-bugs] [Bug 68153] EDITING: Query input in foreignkey-field impossible, when two tables in the query.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=68153

--- Comment #17 from Howard Johnson <BridgeportContractor at gmail.com> ---
> > What were talking about here is the ability to edit many-to-one relations in
> > queries, and in forms based on those queries.
> 
> Not quite. I use several related data forms/subforms (within the same
> document window) to edit stuff based on JOIN. Don't perform the JOIN in the
> query itself, but through the "link master fields" and "link slave fields"
> of data forms & subforms.

As I pointed out before, forms/subforms deal with "has" relationships (main
table has children; where FKs are in the children and point to the main table),
not "is" relationships (where FKs are in the parents and points to
enumerations).

Also to be complete, you can use list-boxes in forms to edit "is"
relationships, but because the underlying data is not what's getting edited
that is another issue.



> ... If the database engine that you use (such as
> embedded HSQLDB 1.8, MySQL, PostgreSQL, ...) cannot do something, Base will
> not do it for you.

As I said before:  MySQL can do this, and I can prove it because Access, when
connected to MySQL, to the very same database and tables, can do this.  Again
to be clear I'm testing the exact same database and tables in Access as in LO
Base.  Access edits the FK, Base does not.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170601/b6052c71/attachment.html>