2 Replies Latest reply on Jun 4, 2010 2:48 AM by Jon1009

    Getting data from another filemaker file

    Jon1009

      Title

      Getting data from another filemaker file

      Post

      Ive got a database with a information about the account holder. the fields ive got are AccountName, Position and Signature.

       

      In another database Iam creating reports which has two places to contain the above information for Report Prepared by and  Report Issued by. The fields i have are

       

      Report Prepared by                           Report Issued by

      Prepared by position                         Issued by position

      Prepared by signature                       Issued by signature

       

      Ive got Names in the Report Prepared by and Report Issued by that will match records in AccountName field in the first database. What I want to do is check the names listed in Report Prepared by and Report Issued by and place the related position and signature in the other fields

       

      Windows Vista Filemaker 10

       

      Cheers Jon

       

       

        • 1. Re: Getting data from another filemaker file
          LaRetta_1

          Hi Jon,

           

          You might want to leave your Accounts table alone.  In your graph, select Accounts and hit the 'double plus' to create a second occurrence of Accounts.  Name it Accounts_Preparer.  Then relate this table occurrence to Reports as:

           

          Reports::Prepared By = Accounts_Preparer::Account Name

           

          ... then place Position and Signature fields from Accounts_Preparer directly on your Reports layout.  Repeat with Issued By (creating another occurrence of Accounts called Accounts_Issuer).

           

          You do not need fields in your reports table for the Position and Signature.  Since you have a relationship back to Accounts (and the Accounts table is the 'one' side to 'many' reports, you can use the relationship to pull and display data in Reports as required.  This is the basis of normalization - data only appears once in a solution and the information is displayed (through relationships) as required.  And that is why I named the Accounts table - so you can easily tell by the table/field name, which relationship (person) is being displayed on your reports when you place them. :smileyhappy:

          • 2. Re: Getting data from another filemaker file
            Jon1009

            Thank you so much!!:smileyhappy:  I was trying to over complicate it with scripts.

             

             

            I'll get the hang of this filemaker one day

             

            Thanks again :)