Path: csiph.com!aioe.org!.POSTED!not-for-mail
From: Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups: comp.databases.filemaker
Subject: Re: Problem with Linked Record in Layout
Date: Fri, 12 Feb 2016 16:40:19 +1300
Organization: Aioe.org NNTP Server
Lines: 35
Message-ID: <120220161640193816%HelpfulHarry@BusyWorking.com>
References: <1mig8xl.1ecfd0m1tae6wbN%csampson@inetworld.net>
NNTP-Posting-Host: haD+OImfFYRQ16ABS7oirw.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Thoth/1.8.4 (Carbon/OS X)
X-Notice: Filtered by postfilter v. 0.8.2
X-Face: vIZzK[X\z-._]-_:U?l@cBtwg<{a>ggn\mH}Vs>38E,#R%7h%U0'=4;1Q=erO %[T#a{YJfGvAbWmE@f_h]<rQ30+q;vqA^FUVx%\9{@r{gt${p^.L~bemFF@WY$r9fhuA F"1)$0+MgN+j8OO<SAec%$P;!M4Aj/kVitK5\xKmed-/3$2LiT1nI!-lKjt0B!qP_E{V ja+\#+[_uq8",IkoIF3M0}}qCD(&
Xref: csiph.com comp.databases.filemaker:2569

In article <1mig8xl.1ecfd0m1tae6wbN%csampson@inetworld.net>, Charles H.
Sampson <csampson@inetworld.net> wrote:
> 
> In an earlier thread, we established that what I've been doing is not
> necessarily bad or wrong. Based on that, here's my problem.
> 
> I have a database containing four related tables. (There are two other
> independent tables used for generating reports.) Two of the tables are
> related with a simple one-to-many relationship. I have a layout for the
> table on the "one" side of this relationship. It has three ordinary
> fields and a field into the related table. There is also a portal into a
> third table. The field into the related table displays the related data
> as a drop-down list. Auto-complete is on.
> 
> This setup has worked well for a few years. Suddenly, I can no longer
> enter data into this field when creating a new record.  The first three
> fields are no problem. I can't eve put the cursor into the fourth field.
> 
> When I look at an existing record, I see that the drop-down list is
> showing values from the wrong field of the related table. Still, when I
> enter a "proper" value (from the correct field), it works. The value
> displayed is the one I entered. However, clicking in that field again
> gives me the drop-down list of values from the wrong filed.
> 
> I've had some success with duplicating a existing record and then
> editing the copy to have the values I want for the new record. I'm
> uncomfortable with that.
> 
> Any ideas? As always, thanks in advance.

It sounds like the field's pop-up menu value list definition is wonky.
Perhaps it's using the wrong field in the Relationship link or simply
using a pre-set value list.

Helpful Harry  :o)