Groups > comp.databases.filemaker > #2569

Re: Problem with Linked Record in Layout

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> (permalink)
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

Show key headers only | View raw

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)

Thread

Problem with Linked Record in Layout csampson@inetworld.net (Charles H. Sampson) - 2016-02-11 10:15 -0800
  Re: Problem with Linked Record in Layout Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-02-12 16:40 +1300
    Re: Problem with Linked Record in Layout csampson@inetworld.net (Charles H. Sampson) - 2016-02-14 11:54 -0800
      Re: Problem with Linked Record in Layout Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-02-15 18:09 +1300

csiph-web