Thanks David that is exactly what I was looking for.
Peter
On May 20, 2008, at 3:11 PM, David McQueen wrote:
Hi Peter,
Set up 4 global fields in your display table (the table you are
working in) of the same type of data as the issue identifier in
your articles table. Set up separate relationships from each
global in your display table back to the articles table, using the
issues identifier field. These are the relationships that will be
used in your four display portals to see the articles in each of
the issues.
You now need some mechanism to populate the global fields - This
could be direct entry, a selection portal or drop down list of all
issues, filtered portals etc. The idea is you want to be able to
easily populate those globals and easily clear them also.
HTH
Dave McQueen
Hi Folks:
I am running fmp8.5 and I'm attempting to set up a layout that has
four portals on it. Each portal will show records from one of four
issues (as in magazines) based on the volume number. So articles
assigned to volume 1 issue 1 will show up in portal A; volume 1
issue 2 in portal B etc.
But I'm confused on how to establish the relationship so that only
the articles assigned to issue 2 show up in portal B. Then I will
want to be able to change the issue that the article will run in
or even the volume number and have the article show up in the
appropriate portal.
Is this possible the way I'm seeing it?
TIA,
Peter
--
David A. McQueen
LICHEN Software
Barrie, ON, Canada
705-720-9022
705-728-2289
www.lichen-software.com
