<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#c20">Comment # 20</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 Lionel Elie Mamane from <a href="show_bug.cgi?id=68153#c18">comment #18</a>)
<span class="quote">> That was not my question. Read my question again.</span >
Ok, I see you ask a very excellent question!, one that will lead you to the
solution in fact...
The answer is a riddle: neither, and both, but timing is everything.
When the user moves the focus after editing a FK (individual field) not just up
or down, but also left or right, the query needs to update the pointed to
record and re-display the line, thus updating the other fields as necessary.
So then if another non-FK field or several are edited, the edits occur in the
correct sequence (timing).
<span class="quote">>If edit FK-field
>Then update query before moving to next field</span >
In other words, the query GUI is not a line editor except in the simple case of
a simple query of only one table.
In a query of a related records the query becomes simple fields and link
fields, and each need to be treated differently. Editing link fields
immediately causes certain parts of the query to update. Editing non-link
fields only update the underlying record when up/down record motion occurs.
I didn't think of this myself; I looked at how Access did it. I had been using
it so long I didn't even know how it worked till yesterday, I just knew that it
worked.</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>