[FX.php List] why doesn't a fields show? (Resolved)

[Chris Hansen]

John,

If I understand what you're saying correctly, I think this issue is  
actually a password issue (as Alex suggested), and NOT related to  
separate files.  I created two fresh FileMaker 9 files, related them,  
and then added fields from the second file to the first one, here's  
the related metadata:

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="text1" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="text2" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Rel_Test2::number1"  
TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Rel_Test2::number2"  
TYPE="NUMBER"/>

Note that it does seem to me that there may have been a version of  
FileMaker server with a bug related to separate files, but at least in  
the latest version of FMSA9 (9.0.3.326 on my Mac OS X machine) related  
fields in separate files work fine, UNLESS the username and password  
used doesn't have the necessary access to view those fields.  Note  
that insufficient privileges to view a field will cause exactly what  
you're seeing.

HTH

--Chris Hansen
   FileMaker 7/8/9 Certified Developer
   Creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org

On Jul 2, 2008, at 9:38 AM, CSInfo wrote:

> I resolved my own issue,
> The data DOES need to be in a local table. An example:
> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Invoices::Invoice Number"  
> TYPE="NUMBER"/>"
> Invoices is a local table in my .fp7 file.
> thanks for reading....
> John
>
> From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org 
> ] On Behalf Of CSInfo
> Sent: Wednesday, July 02, 2008 10:29 AM
> To: 'FX.php Discussion List'
> Subject: [FX.php List] why doesn't a fields show?
>
> I have a layout that has some local and related fields on it.  When  
> I look at the XML, the related fields to not show.
> In order to get the data do I have to query the second database  
> (From a second .fp7 file)? Or should the data be showing from the  
> relationship?
>
> Clip from XML result:
> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Phone3Number" TYPE="TEXT"/>
> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="" TYPE=""/>
>
> the second fields should show DJ_Service::Profile where DJ_Service  
> is a table from the second .fp7 file.
>
> Thanks,
> John Funk
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list