[FX.php List] Related or Not

[Andrew Denman]

I believe you need to create a user account in each file with the same
Privilege Set or Username (I'm not sure which one it is at the moment).  The
thing I know for sure: make sure the privileges allow the web user access to
all of the fields the relationship is based on - if it can't see the data it
doesn't create the relationship.
 
Andrew Denman


  _____  

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of
gerry.charest at agfa.com
Sent: Thursday, October 26, 2006 6:35 AM
To: FX.php Discussion List
Subject: [FX.php List] Related or Not
 
Hi everyone,

I'm in the thick of things rebuilding several FMP5 CDML web based solutions
converting them to FMP8 and PHP. Each solution contains common elements or
has need of like functions (log-in, document storage, email etc.). Rather
than duplicating these features and others in multitabled files and
replicating the data all over the place. I have broken out the common
elements to separate data files and used file references to establish the
relationships where necessary. Creating common elements as shared resources.
>From a database perspective this is looking much cleaner than the older FMP5
solutions. 

I chose to use separate files for each task as each contains a substantial
amount of data, well within the FMP limits but still a mouth full. Smaller
related data requirements are maintained within the file for each solution.
Needless to say portals are used everywhere. PHP has been great for
displaying the related data quickly and efficiently, and here is the rub,
related data from the same file works great. Attempting to display data from
a portal created using a file reference is not displayed in the array. I
have resorted to another query to collect the external files data. My
question is this, Is this normal behavior or is there some trick I'm missing
to make all the data available in the layout available from a single query?
Thoughts and observations?

Best
Gerry
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20061027/0ec42cf5/attachment-0001.html