Groups > comp.databases.filemaker > #2564

Re: 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: Linked Record in Layout
Date	Mon, 08 Feb 2016 16:52:45 +1300
Organization	Aioe.org NNTP Server
Lines	33
Message-ID	<080220161652451040%HelpfulHarry@BusyWorking.com> (permalink)
References	<1mi8zn4.1i2u3kg1qpwdk2N%csampson@inetworld.net>
NNTP-Posting-Host	PK01p1B0Fv5gnC1N+nqpHQ.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:2564

Show key headers only | View raw

In article <1mi8zn4.1i2u3kg1qpwdk2N%csampson@inetworld.net>, Charles H.
Sampson <csampson@inetworld.net> wrote:
> 
> When I was learning the FileMaker way of doing things, I created a
> number of layouts in which a "regular" field showed data from a related
> table. That is, without benefit of a portal.
> 
> By and large, this has worked as I wanted it to. I'm currently having
> trouble with one such layout. Before I describe that problem
> specifically, I'd like to get information about this approach in
> general. When is this way of doing things acceptable and when should
> portals be used? I realize that the answers to these questions might be
> "never" and "always".

As always, it will depend on what you are trying to achieve and why.

A Portal is usually used to show data from multiple related records on
the layout for the Parent record. It's usually not a good idea to use
Portals on print / Preview layouts, but instead print from a layout for
the Child records (using a backwards Relationship link to obtain Parent
record data if needed).

Putting a single related field onto a Parent record layout will only
ever display the data for the FIRST related record (which record is
"first" will depend on the sort order for the Relationship).

You can of course use also use a single calculated or Summary fields in
the Parent record table to do things like Sum or Average all related
Child record data via the Relationship link.
e.g.    RelatedAverage = Average(Relationship::ChildNumberField)

Helpful Harry  :o)

Thread

Linked Record in Layout csampson@inetworld.net (Charles H. Sampson) - 2016-02-07 19:34 -0800
  Re: Linked Record in Layout Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-02-08 16:52 +1300
    Re: Linked Record in Layout Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-02-08 16:58 +1300
    Re: Linked Record in Layout Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2016-02-07 20:09 -0800
  Re: Linked Record in Layout clkaufmann@gmx.ch (Christoph Kaufmann) - 2016-02-08 20:32 +0100

csiph-web