Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #2569

Re: Problem with Linked Record in Layout

Show all headers | 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)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

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