<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: Query input in foreignkey-field impossible, when two tables in the query."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=68153#c23">Comment # 23</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: Query input in foreignkey-field impossible, when two tables in the query."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=68153">bug 68153</a>
from <span class="vcard"><a class="email" href="mailto:BridgeportContractor@gmail.com" title="Howard Johnson <BridgeportContractor@gmail.com>"> <span class="fn">Howard Johnson</span></a>
</span></b>
<pre>(In reply to robert from <a href="show_bug.cgi?id=68153#c22">comment #22</a>)
<span class="quote">> And this is the bug I reported:
>
> You couldn't change the foreign-key-field, but you could change the content
> of the table, which is linked to the first table by this foreign-key.
>
> I would prefer:
> You could change the foreign-key-field, but you could not change the content
> of the table, which is linked to the first table by this foreign-key.
> This would protect the user to unconscious change the content of many rows
> of the first table by changing the content of one field of the second table
> linked to the first by the foreign-key.</span >
Robert, I don't think you see what I'm trying to convey. Let me try to explain
it again.
First, there is no longer any reason that any field in a query should not be
editable. Consider this simple set of tables:
+-----------+
| Table1 ID |
+-----------+ +-----------+
| Table2 FK | -----> | Table2 ID |
+-----------+ +-----------+
| Name | | Title |
+-----------+ +-----------+
| ... | ...
SELECT Table1 ID, Table 2 FK, Name, Table2 ID, Title
FROM Table1 Right Join Table2 ...
+-----------+-----------+------+-----------+-------+
| Table1 ID | Table2 FK | Name | Table2 ID | Title |
+-----------+-----------+------+-----------+-------+
| 0 | 0 | Mike | 0 | Clerk |
+-----------+-----------+------+-----------+-------+
In order:
1) If you edit Table1 ID and move to up or down
then Table 1 is updated.
If you instead move right nothing is done.
2) If you edit Table2 FK from 0 to 1, and then move the focus to another cell,
any prior changes to Table2 ID are pushed to the database, and then
Name, Table2 ID and Title get updated from the new Table2 ID.
3) If you edit Name nothing is done until
If you edit</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>