10 Replies Latest reply on Feb 7, 2012 10:22 PM by Malcolm

    CWP: Accessing data from a table in a different file

    Malcolm

      I am using the Filemaker API to talk to an application that consists of multiple files. Each file has a single table within.

       

      No matter how I try to address the related data I cannot get a result. Here's what I've done so far.

       

      Created a "www" account in each file and given the account read-only privileges and allowed access via fmp_php.

       

      In the primary file I have created new layouts for web use and restricted the www account to those layouts.

       

      On those layouts I have placed the fields I want to use, including related data from the other tables. The related data has a 1:1 relationship so I don't need a portal. I simply placed the fields onto the layout.

       

      When I try to use the the field the value is empty.

      When I try to access the relatedSet the result is an error.

      When I try to use calc fields which use the related data the value is empty.

       

      However, I created a new table in the primary file, set up a relationship and created a few records. I put a field from that table onto the web layouts and I am able to get data from it.

       

      All this points to an issue with permissions but I'm fairly sure that I've covered those bases.

       

      Am I able to configure the databases so that I can pull data from a table in a different file? Or do I have to address each file independently?


      malcolm

        • 1. Re: CWP: Accessing data from a table in a different file
          LyndsayHowarth

          Hi Malcolm,

           

          You will need to define a new $fm for each database... so you can name the databases and their associated username and passwords and IP separately.

           

          Message was edited by: Lyndsay Howarth ie... one can be $fm_Main and the next can be $fm_Data etc

          • 2. Re: CWP: Accessing data from a table in a different file
            LyndsayHowarth

            whoops... I should have read that more thoroughly...

             

            I do this all the time... I have one solution I build for which is 100% data separation. I must admit that when I access big chunks of data I go to the data table directly, but with the other values I don't...

             

            I don't know specifically if I have tried it via a portal though... I'll investigate...

             

            - Lyndsay

            • 3. Re: CWP: Accessing data from a table in a different file
              Malcolm

              Are you positive that you are able to reference related data from a table in separate file?

               

              The thing that I find most odd is that I can't even get data from a calculated field that referenced the other table. At that point I thought, the calc field is now a part of the local file's security / permissions so I should be able to get the data.

               

              When asking for the related record set using getRelatedSet() the error sent back in the resulting array is that the specified table doesn't exist. I put a portal onto the layout and put the field into it and saved it.

               

              Malcolm

              • 4. Re: CWP: Accessing data from a table in a different file
                mbraendle

                Hmm. In one of our websites, we use data from two files with just addressing one file in the $fm = new FileMaker() ... definition. And it works.

                 

                Do you have a table occurence of the related table of the other file in your main file accessed by the PHP code? I assume yes. Then you should check your code or even show it to us.

                • 5. Re: CWP: Accessing data from a table in a different file
                  mbraendle

                  Or said in another way: The essential point is to replicate all the tables of the related file, including the relations, in the main file, if they need to be accessed by PHP.

                  • 6. Re: CWP: Accessing data from a table in a different file
                    Malcolm

                    In this case it is a solution that has 21 files. Each of those has only one internal table. Of course, each file has many table occurrences as it has to link to tables in all the other files.

                     

                    We are only interested in three of the files. I've chosen to point the web site at the "artworks" file. This is linked to "artists" and "images". There is a n to one relationship between artworks and artist, and a one to one relationship between artworks and images. The file already has these relationships defined.

                     

                    I'll run some code and post the results.

                    • 7. Re: CWP: Accessing data from a table in a different file
                      Malcolm

                      The output from print_r($record) is printed in full below.

                       

                      The table I am querying is named "T02" it might be called "artwork". The other tables of interest are "T01" - "artist", "T10_1" - "image" and "abc" which is a table I created in the same file as "T02" for debugging purposes. 

                       

                      The things that I can see that are odd are:

                       

                      1. The Artist_FirstName_Surname array is empty. This field should not be empty, it has a value. This is a calc field that references a field in table "T01" (artist).

                       

                                             [Artist_FirstName_Surname] => Array
                                               (
                                                   [0] =>
                                                )  
                      

                       

                      2. I created a second table in this file, called "abc". It contains a single field called "test" and I've created a relationship. This related set is displayed and the field "test" is accessible and included in the [_fields] array. You can see it listed here. I can get data from that table.

                                                   [_relatedSets] => Array
                                                                            [_name] => abc
                                                                           [_fields] => Array
                                                                               (
                                                                                   [abc::test] => FileMaker_Field Object
                      

                       

                      3. In contrast, the related set coming from the table called "T01" (artist) does not have any fields in the [_fields] array. The same is true for table "T10_1" (image). The relationship for the table is valid and data is visible on the layout for all records.

                       

                                                                             [_name] => T01
                                                                           [_fields] => Array
                                                                               (
                                                                                   [] => FileMaker_Field Object 
                      

                       

                      What follows is the full output from print_r()

                      FileMaker_Record Object
                      (
                          [_impl] => FileMaker_Record_Implementation Object
                              (
                                  [_fields] => Array
                                      (
                                          [Artwork] => Array
                                              (
                                                  [0] => Red Abstract
                                              )
                      
                                          [Status_Artwork] => Array
                                              (
                                                  [0] => Sold
                                              )
                      
                                          [Category_Display] => Array
                                              (
                                                  [0] => Painting
                                              )
                      
                                          [M] => Array
                                              (
                                                  [0] => Oil on canvas
                                              )
                      
                                          [Edition_Final] => Array
                                              (
                                                  [0] => 
                                              )
                      
                                          [Dim] => Array
                                              (
                                                  [0] => 196 x 170cm
                      Frame: 198 x 172cm
                                              )
                      
                                          [Catalogue_Number] => Array
                                              (
                                                  [0] => 5
                                              )
                      
                                          [List Price] => Array
                                              (
                                                  [0] => 80000
                                              )
                      
                                          [Location] => Array
                                              (
                                                  [0] => Attic E
                                              )
                      
                                          [Comment] => Array
                                              (
                                                  [0] => xmas show 2001 20%
                                              )
                      
                                          [Tag_Show] => Array
                                              (
                                                  [0] => 
                                              )
                      
                                          [Tag_Artwork] => Array
                                              (
                                                  [0] => 
                                              )
                      
                                          [Tag_Loan] => Array
                                              (
                                                  [0] => 
                                              )
                      
                                          [KEY_Artwork] => Array
                                              (
                                                  [0] => 730207126.033421
                                              )
                      
                                          [Framed Display] => Array
                                              (
                                                  [0] => Yes
                                              )
                      
                                          [PRICE_Rental] => Array
                                              (
                                                  [0] => 
                                              )
                      
                                          [Artist_FirstName_Surname] => Array
                                              (
                                                  [0] => 
                                              )
                      
                                          [(Status)] => Array
                                              (
                                                  [0] => Sold
                                              )
                      
                                      )
                      
                                  [V5e7ec2d5] => Array
                                      (
                                      )
                      
                                  [_recordId] => 14147
                                  [_modificationId] => 48
                                  [_layout] => FileMaker_Layout Object
                                      (
                                          [_impl] => FileMaker_Layout_Implementation Object
                                              (
                                                  [_fm] => FileMaker_Implementation Object
                                                      (
                                                          [V73ee434e] => Array
                                                              (
                                                                  [charset] => UTF-8
                                                                  [locale] => en
                                                                  [logLevel] => 3
                                                                  [hostspec] => http://127.0.0.1
                                                                  [recordClass] => FileMaker_Record
                                                                  [prevalidate] => 
                                                                  [database] => T02
                                                                  [username] => xxxxxx
                                                                  [password] => xxxxxx
                                                              )
                      
                                                          [Vea4b3413] => 
                                                          [V9a3dcbce] => 
                                                      )
                      
                                                  [_name] => www_artwork_full_details
                                                  [_fields] => Array
                                                      (
                                                          [Artwork] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Artwork
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => normal
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [Status_Artwork] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Status_Artwork
                                                                          [_autoEntered] => 1
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => normal
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [Category_Display] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Category_Display
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => calculation
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [M] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => M
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => calculation
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [Edition_Final] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Edition_Final
                                                                          [_autoEntered] => 1
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => calculation
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [Dim] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Dim
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => calculation
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [Catalogue_Number] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Catalogue_Number
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => number
                                                                          [_type] => normal
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [List Price] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => List Price
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => number
                                                                          [_type] => calculation
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [Location] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Location
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => normal
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [Comment] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Comment
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => normal
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [Tag_Show] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Tag_Show
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => normal
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [Tag_Artwork] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Tag_Artwork
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => normal
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [Tag_Loan] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Tag_Loan
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => normal
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [KEY_Artwork] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => KEY_Artwork
                                                                          [_autoEntered] => 1
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => normal
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [Framed Display] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Framed Display
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => calculation
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [PRICE_Rental] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => PRICE_Rental
                                                                          [_autoEntered] => 
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => number
                                                                          [_type] => normal
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [Artist_FirstName_Surname] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => Artist_FirstName_Surname
                                                                          [_autoEntered] => 1
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => calculation
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                          [(Status)] => FileMaker_Field Object
                                                              (
                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_name] => (Status)
                                                                          [_autoEntered] => 1
                                                                          [_global] => 
                                                                          [_maxRepeat] => 1
                                                                          [_validationMask] => 0
                                                                          [_validationRules] => Array
                                                                              (
                                                                              )
                      
                                                                          [_result] => text
                                                                          [_type] => normal
                                                                          [_valueList] => 
                                                                          [_styleType] => 
                                                                          [_maxCharacters] => 0
                                                                      )
                      
                                                              )
                      
                                                      )
                      
                                                  [_relatedSets] => Array
                                                      (
                                                          [abc] => FileMaker_RelatedSet Object
                                                              (
                                                                  [_impl] => FileMaker_RelatedSet_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_fm] => FileMaker_Implementation Object
                                                                              (
                                                                                  [V73ee434e] => Array
                                                                                      (
                                                                                          [charset] => UTF-8
                                                                                          [locale] => en
                                                                                          [logLevel] => 3
                                                                                          [hostspec] => http://127.0.0.1
                                                                                          [recordClass] => FileMaker_Record
                                                                                          [prevalidate] => 
                                                                                          [database] => T02
                                                                                          [username] => xxxxxx
                                                                                          [password] => xxxxxx
                                                                                      )
                      
                                                                                  [Vea4b3413] => 
                                                                                  [V9a3dcbce] => 
                                                                              )
                      
                                                                          [_name] => abc
                                                                          [_fields] => Array
                                                                              (
                                                                                  [abc::test] => FileMaker_Field Object
                                                                                      (
                                                                                          [_impl] => FileMaker_Field_Implementation Object
                                                                                              (
                                                                                                  [_layout] => FileMaker_RelatedSet Object
                       *RECURSION*
                                                                                                  [_name] => abc::test
                                                                                                  [_autoEntered] => 
                                                                                                  [_global] => 
                                                                                                  [_maxRepeat] => 1
                                                                                                  [_validationMask] => 0
                                                                                                  [_validationRules] => Array
                                                                                                      (
                                                                                                      )
                      
                                                                                                  [_result] => text
                                                                                                  [_type] => normal
                                                                                                  [_valueList] => 
                                                                                                  [_styleType] => 
                                                                                                  [_maxCharacters] => 0
                                                                                              )
                      
                                                                                      )
                      
                                                                              )
                      
                                                                      )
                      
                                                              )
                      
                                                          [T01] => FileMaker_RelatedSet Object
                                                              (
                                                                  [_impl] => FileMaker_RelatedSet_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_fm] => FileMaker_Implementation Object
                                                                              (
                                                                                  [V73ee434e] => Array
                                                                                      (
                                                                                          [charset] => UTF-8
                                                                                          [locale] => en
                                                                                          [logLevel] => 3
                                                                                          [hostspec] => http://127.0.0.1
                                                                                          [recordClass] => FileMaker_Record
                                                                                          [prevalidate] => 
                                                                                          [database] => T02
                                                                                          [username] => xxxxxx
                                                                                          [password] => xxxxxx
                                                                                      )
                      
                                                                                  [Vea4b3413] => 
                                                                                  [V9a3dcbce] => 
                                                                              )
                      
                                                                          [_name] => T01
                                                                          [_fields] => Array
                                                                              (
                                                                                  [] => FileMaker_Field Object
                                                                                      (
                                                                                          [_impl] => FileMaker_Field_Implementation Object
                                                                                              (
                                                                                                  [_layout] => FileMaker_RelatedSet Object
                       *RECURSION*
                                                                                                  [_name] => 
                                                                                                  [_autoEntered] => 
                                                                                                  [_global] => 
                                                                                                  [_maxRepeat] => 1
                                                                                                  [_validationMask] => 0
                                                                                                  [_validationRules] => Array
                                                                                                      (
                                                                                                      )
                      
                                                                                                  [_result] => unknown
                                                                                                  [_type] => unknown
                                                                                                  [_valueList] => 
                                                                                                  [_styleType] => 
                                                                                                  [_maxCharacters] => 0
                                                                                              )
                      
                                                                                      )
                      
                                                                              )
                      
                                                                      )
                      
                                                              )
                      
                                                          [T10_1] => FileMaker_RelatedSet Object
                                                              (
                                                                  [_impl] => FileMaker_RelatedSet_Implementation Object
                                                                      (
                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                          [_fm] => FileMaker_Implementation Object
                                                                              (
                                                                                  [V73ee434e] => Array
                                                                                      (
                                                                                          [charset] => UTF-8
                                                                                          [locale] => en
                                                                                          [logLevel] => 3
                                                                                          [hostspec] => http://127.0.0.1
                                                                                          [recordClass] => FileMaker_Record
                                                                                          [prevalidate] => 
                                                                                          [database] => T02
                                                                                          [username] => xxxxxx
                                                                                          [password] => xxxxxx
                                                                                      )
                      
                                                                                  [Vea4b3413] => 
                                                                                  [V9a3dcbce] => 
                                                                              )
                      
                                                                          [_name] => T10_1
                                                                          [_fields] => Array
                                                                              (
                                                                                  [] => FileMaker_Field Object
                                                                                      (
                                                                                          [_impl] => FileMaker_Field_Implementation Object
                                                                                              (
                                                                                                  [_layout] => FileMaker_RelatedSet Object
                       *RECURSION*
                                                                                                  [_name] => 
                                                                                                  [_autoEntered] => 
                                                                                                  [_global] => 
                                                                                                  [_maxRepeat] => 1
                                                                                                  [_validationMask] => 0
                                                                                                  [_validationRules] => Array
                                                                                                      (
                                                                                                      )
                      
                                                                                                  [_result] => unknown
                                                                                                  [_type] => unknown
                                                                                                  [_valueList] => 
                                                                                                  [_styleType] => 
                                                                                                  [_maxCharacters] => 0
                                                                                              )
                      
                                                                                      )
                      
                                                                              )
                      
                                                                      )
                      
                                                              )
                      
                                                      )
                      
                                                  [_valueLists] => Array
                                                      (
                                                      )
                      
                                                  [Vab234ad8] => Array
                                                      (
                                                      )
                      
                                                  [_database] => T02
                                                  [_extended] => 
                                              )
                      
                                      )
                      
                                  [_fm] => FileMaker_Implementation Object
                                      (
                                          [V73ee434e] => Array
                                              (
                                                  [charset] => UTF-8
                                                  [locale] => en
                                                  [logLevel] => 3
                                                  [hostspec] => http://127.0.0.1
                                                  [recordClass] => FileMaker_Record
                                                  [prevalidate] => 
                                                  [database] => T02
                                                  [username] => xxxxxx
                                                  [password] => xxxxxx
                                              )
                      
                                          [Vea4b3413] => 
                                          [V9a3dcbce] => 
                                      )
                      
                                  [_relatedSets] => Array
                                      (
                                          [abc] => Array
                                              (
                                                  [0] => FileMaker_Record Object
                                                      (
                                                          [_impl] => FileMaker_Record_Implementation Object
                                                              (
                                                                  [_fields] => Array
                                                                      (
                                                                          [abc::test] => Array
                                                                              (
                                                                                  [0] => a
                                                                              )
                      
                                                                      )
                      
                                                                  [V5e7ec2d5] => Array
                                                                      (
                                                                      )
                      
                                                                  [_recordId] => 1
                                                                  [_modificationId] => 1
                                                                  [_layout] => FileMaker_RelatedSet Object
                                                                      (
                                                                          [_impl] => FileMaker_RelatedSet_Implementation Object
                                                                              (
                                                                                  [_layout] => FileMaker_Layout Object
                                                                                      (
                                                                                          [_impl] => FileMaker_Layout_Implementation Object
                                                                                              (
                                                                                                  [_fm] => FileMaker_Implementation Object
                                                                                                      (
                                                                                                          [V73ee434e] => Array
                                                                                                              (
                                                                                                                  [charset] => UTF-8
                                                                                                                  [locale] => en
                                                                                                                  [logLevel] => 3
                                                                                                                  [hostspec] => http://127.0.0.1
                                                                                                                  [recordClass] => FileMaker_Record
                                                                                                                  [prevalidate] => 
                                                                                                                  [database] => T02
                                                                                                                  [username] => xxxxxx
                                                                                                                  [password] => xxxxxx
                                                                                                              )
                      
                                                                                                          [Vea4b3413] => 
                                                                                                          [V9a3dcbce] => 
                                                                                                      )
                      
                                                                                                  [_name] => www_artwork_full_details
                                                                                                  [_fields] => Array
                                                                                                      (
                                                                                                          [Artwork] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Artwork
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Status_Artwork] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Status_Artwork
                                                                                                                          [_autoEntered] => 1
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Category_Display] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Category_Display
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [M] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => M
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Edition_Final] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Edition_Final
                                                                                                                          [_autoEntered] => 1
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Dim] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Dim
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Catalogue_Number] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Catalogue_Number
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => number
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [List Price] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => List Price
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => number
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Location] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Location
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Comment] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Comment
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Tag_Show] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Tag_Show
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Tag_Artwork] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Tag_Artwork
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Tag_Loan] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Tag_Loan
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [KEY_Artwork] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => KEY_Artwork
                                                                                                                          [_autoEntered] => 1
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Framed Display] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Framed Display
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [PRICE_Rental] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => PRICE_Rental
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => number
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Artist_FirstName_Surname] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Artist_FirstName_Surname
                                                                                                                          [_autoEntered] => 1
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [(Status)] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => (Status)
                                                                                                                          [_autoEntered] => 1
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                      )
                      
                                                                                                  [_relatedSets] => Array
                                                                                                      (
                                                                                                          [abc] => FileMaker_RelatedSet Object
                       *RECURSION*
                                                                                                          [T01] => FileMaker_RelatedSet Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_RelatedSet_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_fm] => FileMaker_Implementation Object
                                                                                                                              (
                                                                                                                                  [V73ee434e] => Array
                                                                                                                                      (
                                                                                                                                          [charset] => UTF-8
                                                                                                                                          [locale] => en
                                                                                                                                          [logLevel] => 3
                                                                                                                                          [hostspec] => http://127.0.0.1
                                                                                                                                          [recordClass] => FileMaker_Record
                                                                                                                                          [prevalidate] => 
                                                                                                                                          [database] => T02
                                                                                                                                          [username] => xxxxxx
                                                                                                                                          [password] => xxxxxx
                                                                                                                                      )
                      
                                                                                                                                  [Vea4b3413] => 
                                                                                                                                  [V9a3dcbce] => 
                                                                                                                              )
                      
                                                                                                                          [_name] => T01
                                                                                                                          [_fields] => Array
                                                                                                                              (
                                                                                                                                  [] => FileMaker_Field Object
                                                                                                                                      (
                                                                                                                                          [_impl] => FileMaker_Field_Implementation Object
                                                                                                                                              (
                                                                                                                                                  [_layout] => FileMaker_RelatedSet Object
                       *RECURSION*
                                                                                                                                                  [_name] => 
                                                                                                                                                  [_autoEntered] => 
                                                                                                                                                  [_global] => 
                                                                                                                                                  [_maxRepeat] => 1
                                                                                                                                                  [_validationMask] => 0
                                                                                                                                                  [_validationRules] => Array
                                                                                                                                                      (
                                                                                                                                                      )
                      
                                                                                                                                                  [_result] => unknown
                                                                                                                                                  [_type] => unknown
                                                                                                                                                  [_valueList] => 
                                                                                                                                                  [_styleType] => 
                                                                                                                                                  [_maxCharacters] => 0
                                                                                                                                              )
                      
                                                                                                                                      )
                      
                                                                                                                              )
                      
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [T10_1] => FileMaker_RelatedSet Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_RelatedSet_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_fm] => FileMaker_Implementation Object
                                                                                                                              (
                                                                                                                                  [V73ee434e] => Array
                                                                                                                                      (
                                                                                                                                          [charset] => UTF-8
                                                                                                                                          [locale] => en
                                                                                                                                          [logLevel] => 3
                                                                                                                                          [hostspec] => http://127.0.0.1
                                                                                                                                          [recordClass] => FileMaker_Record
                                                                                                                                          [prevalidate] => 
                                                                                                                                          [database] => T02
                                                                                                                                          [username] => xxxxxx
                                                                                                                                          [password] => xxxxxx
                                                                                                                                      )
                      
                                                                                                                                  [Vea4b3413] => 
                                                                                                                                  [V9a3dcbce] => 
                                                                                                                              )
                      
                                                                                                                          [_name] => T10_1
                                                                                                                          [_fields] => Array
                                                                                                                              (
                                                                                                                                  [] => FileMaker_Field Object
                                                                                                                                      (
                                                                                                                                          [_impl] => FileMaker_Field_Implementation Object
                                                                                                                                              (
                                                                                                                                                  [_layout] => FileMaker_RelatedSet Object
                       *RECURSION*
                                                                                                                                                  [_name] => 
                                                                                                                                                  [_autoEntered] => 
                                                                                                                                                  [_global] => 
                                                                                                                                                  [_maxRepeat] => 1
                                                                                                                                                  [_validationMask] => 0
                                                                                                                                                  [_validationRules] => Array
                                                                                                                                                      (
                                                                                                                                                      )
                      
                                                                                                                                                  [_result] => unknown
                                                                                                                                                  [_type] => unknown
                                                                                                                                                  [_valueList] => 
                                                                                                                                                  [_styleType] => 
                                                                                                                                                  [_maxCharacters] => 0
                                                                                                                                              )
                      
                                                                                                                                      )
                      
                                                                                                                              )
                      
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                      )
                      
                                                                                                  [_valueLists] => Array
                                                                                                      (
                                                                                                      )
                      
                                                                                                  [Vab234ad8] => Array
                                                                                                      (
                                                                                                      )
                      
                                                                                                  [_database] => T02
                                                                                                  [_extended] => 
                                                                                              )
                      
                                                                                      )
                      
                                                                                  [_fm] => FileMaker_Implementation Object
                                                                                      (
                                                                                          [V73ee434e] => Array
                                                                                              (
                                                                                                  [charset] => UTF-8
                                                                                                  [locale] => en
                                                                                                  [logLevel] => 3
                                                                                                  [hostspec] => http://127.0.0.1
                                                                                                  [recordClass] => FileMaker_Record
                                                                                                  [prevalidate] => 
                                                                                                  [database] => T02
                                                                                                  [username] => xxxxxx
                                                                                                  [password] => xxxxxx
                                                                                              )
                      
                                                                                          [Vea4b3413] => 
                                                                                          [V9a3dcbce] => 
                                                                                      )
                      
                                                                                  [_name] => abc
                                                                                  [_fields] => Array
                                                                                      (
                                                                                          [abc::test] => FileMaker_Field Object
                                                                                              (
                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                      (
                                                                                                          [_layout] => FileMaker_RelatedSet Object
                       *RECURSION*
                                                                                                          [_name] => abc::test
                                                                                                          [_autoEntered] => 
                                                                                                          [_global] => 
                                                                                                          [_maxRepeat] => 1
                                                                                                          [_validationMask] => 0
                                                                                                          [_validationRules] => Array
                                                                                                              (
                                                                                                              )
                      
                                                                                                          [_result] => text
                                                                                                          [_type] => normal
                                                                                                          [_valueList] => 
                                                                                                          [_styleType] => 
                                                                                                          [_maxCharacters] => 0
                                                                                                      )
                      
                                                                                              )
                      
                                                                                      )
                      
                                                                              )
                      
                                                                      )
                      
                                                                  [_fm] => FileMaker_Implementation Object
                                                                      (
                                                                          [V73ee434e] => Array
                                                                              (
                                                                                  [charset] => UTF-8
                                                                                  [locale] => en
                                                                                  [logLevel] => 3
                                                                                  [hostspec] => http://127.0.0.1
                                                                                  [recordClass] => FileMaker_Record
                                                                                  [prevalidate] => 
                                                                                  [database] => T02
                                                                                  [username] => xxxxxx
                                                                                  [password] => xxxxxx
                                                                              )
                      
                                                                          [Vea4b3413] => 
                                                                          [V9a3dcbce] => 
                                                                      )
                      
                                                                  [_relatedSets] => Array
                                                                      (
                                                                      )
                      
                                                                  [_parent] => FileMaker_Record Object
                       *RECURSION*
                                                              )
                      
                                                      )
                      
                                                  [1] => FileMaker_Record Object
                                                      (
                                                          [_impl] => FileMaker_Record_Implementation Object
                                                              (
                                                                  [_fields] => Array
                                                                      (
                                                                          [abc::test] => Array
                                                                              (
                                                                                  [0] => b
                                                                              )
                      
                                                                      )
                      
                                                                  [V5e7ec2d5] => Array
                                                                      (
                                                                      )
                      
                                                                  [_recordId] => 2
                                                                  [_modificationId] => 1
                                                                  [_layout] => FileMaker_RelatedSet Object
                                                                      (
                                                                          [_impl] => FileMaker_RelatedSet_Implementation Object
                                                                              (
                                                                                  [_layout] => FileMaker_Layout Object
                                                                                      (
                                                                                          [_impl] => FileMaker_Layout_Implementation Object
                                                                                              (
                                                                                                  [_fm] => FileMaker_Implementation Object
                                                                                                      (
                                                                                                          [V73ee434e] => Array
                                                                                                              (
                                                                                                                  [charset] => UTF-8
                                                                                                                  [locale] => en
                                                                                                                  [logLevel] => 3
                                                                                                                  [hostspec] => http://127.0.0.1
                                                                                                                  [recordClass] => FileMaker_Record
                                                                                                                  [prevalidate] => 
                                                                                                                  [database] => T02
                                                                                                                  [username] => xxxxxx
                                                                                                                  [password] => xxxxxx
                                                                                                              )
                      
                                                                                                          [Vea4b3413] => 
                                                                                                          [V9a3dcbce] => 
                                                                                                      )
                      
                                                                                                  [_name] => www_artwork_full_details
                                                                                                  [_fields] => Array
                                                                                                      (
                                                                                                          [Artwork] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Artwork
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Status_Artwork] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Status_Artwork
                                                                                                                          [_autoEntered] => 1
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Category_Display] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Category_Display
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [M] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => M
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Edition_Final] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Edition_Final
                                                                                                                          [_autoEntered] => 1
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Dim] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Dim
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Catalogue_Number] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Catalogue_Number
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => number
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [List Price] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => List Price
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => number
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Location] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Location
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Comment] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Comment
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Tag_Show] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Tag_Show
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Tag_Artwork] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Tag_Artwork
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Tag_Loan] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Tag_Loan
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [KEY_Artwork] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => KEY_Artwork
                                                                                                                          [_autoEntered] => 1
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Framed Display] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Framed Display
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [PRICE_Rental] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => PRICE_Rental
                                                                                                                          [_autoEntered] => 
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => number
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [Artist_FirstName_Surname] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => Artist_FirstName_Surname
                                                                                                                          [_autoEntered] => 1
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => calculation
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [(Status)] => FileMaker_Field Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_name] => (Status)
                                                                                                                          [_autoEntered] => 1
                                                                                                                          [_global] => 
                                                                                                                          [_maxRepeat] => 1
                                                                                                                          [_validationMask] => 0
                                                                                                                          [_validationRules] => Array
                                                                                                                              (
                                                                                                                              )
                      
                                                                                                                          [_result] => text
                                                                                                                          [_type] => normal
                                                                                                                          [_valueList] => 
                                                                                                                          [_styleType] => 
                                                                                                                          [_maxCharacters] => 0
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                      )
                      
                                                                                                  [_relatedSets] => Array
                                                                                                      (
                                                                                                          [abc] => FileMaker_RelatedSet Object
                       *RECURSION*
                                                                                                          [T01] => FileMaker_RelatedSet Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_RelatedSet_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_fm] => FileMaker_Implementation Object
                                                                                                                              (
                                                                                                                                  [V73ee434e] => Array
                                                                                                                                      (
                                                                                                                                          [charset] => UTF-8
                                                                                                                                          [locale] => en
                                                                                                                                          [logLevel] => 3
                                                                                                                                          [hostspec] => http://127.0.0.1
                                                                                                                                          [recordClass] => FileMaker_Record
                                                                                                                                          [prevalidate] => 
                                                                                                                                          [database] => T02
                                                                                                                                          [username] => xxxxxx
                                                                                                                                          [password] => xxxxxx
                                                                                                                                      )
                      
                                                                                                                                  [Vea4b3413] => 
                                                                                                                                  [V9a3dcbce] => 
                                                                                                                              )
                      
                                                                                                                          [_name] => T01
                                                                                                                          [_fields] => Array
                                                                                                                              (
                                                                                                                                  [] => FileMaker_Field Object
                                                                                                                                      (
                                                                                                                                          [_impl] => FileMaker_Field_Implementation Object
                                                                                                                                              (
                                                                                                                                                  [_layout] => FileMaker_RelatedSet Object
                       *RECURSION*
                                                                                                                                                  [_name] => 
                                                                                                                                                  [_autoEntered] => 
                                                                                                                                                  [_global] => 
                                                                                                                                                  [_maxRepeat] => 1
                                                                                                                                                  [_validationMask] => 0
                                                                                                                                                  [_validationRules] => Array
                                                                                                                                                      (
                                                                                                                                                      )
                      
                                                                                                                                                  [_result] => unknown
                                                                                                                                                  [_type] => unknown
                                                                                                                                                  [_valueList] => 
                                                                                                                                                  [_styleType] => 
                                                                                                                                                  [_maxCharacters] => 0
                                                                                                                                              )
                      
                                                                                                                                      )
                      
                                                                                                                              )
                      
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                          [T10_1] => FileMaker_RelatedSet Object
                                                                                                              (
                                                                                                                  [_impl] => FileMaker_RelatedSet_Implementation Object
                                                                                                                      (
                                                                                                                          [_layout] => FileMaker_Layout Object
                       *RECURSION*
                                                                                                                          [_fm] => FileMaker_Implementation Object
                                                                                                                              (
                                                                                                                                  [V73ee434e] => Array
                                                                                                                                      (
                                                                                                                                          [charset] => UTF-8
                                                                                                                                          [locale] => en
                                                                                                                                          [logLevel] => 3
                                                                                                                                          [hostspec] => http://127.0.0.1
                                                                                                                                          [recordClass] => FileMaker_Record
                                                                                                                                          [prevalidate] => 
                                                                                                                                          [database] => T02
                                                                                                                                          [username] => xxxxxx
                                                                                                                                          [password] => xxxxxx
                                                                                                                                      )
                      
                                                                                                                                  [Vea4b3413] => 
                                                                                                                                  [V9a3dcbce] => 
                                                                                                                              )
                      
                                                                                                                          [_name] => T10_1
                                                                                                                          [_fields] => Array
                                                                                                                              (
                                                                                                                                  [] => FileMaker_Field Object
                                                                                                                                      (
                                                                                                                                          [_impl] => FileMaker_Field_Implementation Object
                                                                                                                                              (
                                                                                                                                                  [_layout] => FileMaker_RelatedSet Object
                       *RECURSION*
                                                                                                                                                  [_name] => 
                                                                                                                                                  [_autoEntered] => 
                                                                                                                                                  [_global] => 
                                                                                                                                                  [_maxRepeat] => 1
                                                                                                                                                  [_validationMask] => 0
                                                                                                                                                  [_validationRules] => Array
                                                                                                                                                      (
                                                                                                                                                      )
                      
                                                                                                                                                  [_result] => unknown
                                                                                                                                                  [_type] => unknown
                                                                                                                                                  [_valueList] => 
                                                                                                                                                  [_styleType] => 
                                                                                                                                                  [_maxCharacters] => 0
                                                                                                                                              )
                      
                                                                                                                                      )
                      
                                                                                                                              )
                      
                                                                                                                      )
                      
                                                                                                              )
                      
                                                                                                      )
                      
                                                                                                  [_valueLists] => Array
                                                                                                      (
                                                                                                      )
                      
                                                                                                  [Vab234ad8] => Array
                                                                                                      (
                                                                                                      )
                      
                                                                                                  [_database] => T02
                                                                                                  [_extended] => 
                                                                                              )
                      
                                                                                      )
                      
                                                                                  [_fm] => FileMaker_Implementation Object
                                                                                      (
                                                                                          [V73ee434e] => Array
                                                                                              (
                                                                                                  [charset] => UTF-8
                                                                                                  [locale] => en
                                                                                                  [logLevel] => 3
                                                                                                  [hostspec] => http://127.0.0.1
                                                                                                  [recordClass] => FileMaker_Record
                                                                                                  [prevalidate] => 
                                                                                                  [database] => T02
                                                                                                  [username] => xxxxxx
                                                                                                  [password] => xxxxxx
                                                                                              )
                      
                                                                                          [Vea4b3413] => 
                                                                                          [V9a3dcbce] => 
                                                                                      )
                      
                                                                                  [_name] => abc
                                                                                  [_fields] => Array
                                                                                      (
                                                                                          [abc::test] => FileMaker_Field Object
                                                                                              (
                                                                                                  [_impl] => FileMaker_Field_Implementation Object
                                                                                                      (
                                                                                                          [_layout] => FileMaker_RelatedSet Object
                       *RECURSION*
                                                                                                          [_name] => abc::test
                                                                                                          [_autoEntered] => 
                                                                                                          [_global] => 
                                                                                                          [_maxRepeat] => 1
                                                                                                          [_validationMask] => 0
                                                                                                          [_validationRules] => Array
                                                                                                              (
                                                                                                              )
                      
                                                                                                          [_result] => text
                                                                                                          [_type] => normal
                                                                                                          [_valueList] => 
                                                                                                          [_styleType] => 
                                                                                                          [_maxCharacters] => 0
                                                                                                      )
                      
                                                                                              )
                      
                                                                                      )
                      
                                                                              )
                      
                                                                      )
                      
                                                                  [_fm] => FileMaker_Implementation Object
                                                                      (
                                                                          [V73ee434e] => Array
                                                                              (
                                                                                  [charset] => UTF-8
                                                                                  [locale] => en
                                                                                  [logLevel] => 3
                                                                                  [hostspec] => http://127.0.0.1
                                                                                  [recordClass] => FileMaker_Record
                                                                                  [prevalidate] => 
                                                                                  [database] => T02
                                                                                  [username] => xxxxxx
                                                                                  [password] => xxxxxx
                                                                              )
                      
                                                                          [Vea4b3413] => 
                                                                          [V9a3dcbce] => 
                                                                      )
                      
                                                                  [_relatedSets] => Array
                                                                      (
                                                                      )
                      
                                                                  [_parent] => FileMaker_Record Object
                       *RECURSION*
                                                              )
                      
                                                      )
                      
                                              )
                      
                                          [T01] => Array
                                              (
                                              )
                      
                                          [T10_1] => Array
                                              (
                                              )
                      
                                      )
                      
                                  [_parent] => 
                              )
                      
                      )
                      
                      • 8. Re: CWP: Accessing data from a table in a different file
                        mbraendle

                        Malcom, to be clear: You just need to replicate the tables as TOs, and also the relations in between. No replication of data, of course.

                        Then, in the Web layout, you use these TOs to setup and access the related fields and portals.

                        Also, in both files, the PHP extended privilege set must be checked for the PHP account and the password must be the same.

                        • 9. Re: CWP: Accessing data from a table in a different file
                          Malcolm

                          Hi Martin,

                           

                          The file already contains the TOs that I want to include. The file only contains a single table but it has dozens of TOs. All the relationship needed are already present.

                          I have created a layout for the web.

                          I have created a user account for the web

                          I have created a privilege set for the web and ensured that they have PHP access and they have access to the web layout.

                           

                          The fact that I cannot obtain data from a calculation field that references the same tables makes me thing that there is a deeper problem.

                           

                          I will try using the FX.php library to see if I run into the same problem. I'll also try creating a new database to see if it is a problem with the files.

                           

                          thanks for your help,

                          Malcolm

                          • 10. Re: CWP: Accessing data from a table in a different file
                            Malcolm

                            I found the problem. It was a permissions issue: Network Access Permissions were set to limit the privilege sets who could see the data in those tables. I had created a new privilege set and it wasn't on the list.

                             

                            The nuisance with these permissions settings is that they aren't accessible to the admin when they are running on the server. Or are they?