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
