4 Replies Latest reply on Dec 11, 2009 8:17 AM by comment_1

    Database Relashionships ???

    nathan_george69

      Title

      Database Relashionships ???

      Post

       

      Hi,

       

      I'am trying to attempt to display records from one database (filemaker file)

      in another database (filemaker file) and it is presenting some problems for me.

      I was wondering if any one could help me.

       

      I have a database with all the information i require saved in it and another

      database purly to display information. For some reason i cannot get the databases

      to interact with each other. I have set up the external data source but nothing.???

      CAN ANYONE HELP ME PLEASE ???

       

      nathan_george69

      nathan_george69@hotmail.co.uk

       

      System Spec

      Windows 7, Filemaker Pro 10 A

       

      Thanks :)

        • 1. Re: Database Relashionships ???
          davidanders
            

          Simple formatting will help

          Your origin database  origin, tables and fields

          Your destination database  tables and fields.

          AND your object result 

          • 2. Re: Database Relashionships ???
            comment_1
               You need to place the table/s from the data file onto the relationship graph of the display file. Create a layout for each added table in order to view the records.
            • 3. Re: Database Relashionships ???
              nathan_george69
                 Thanks for getting back to me.

              So if i have the Fields in database 1 :

              Refrence
              Date

              And database 2 :

              Title
              Date

              How do i get the database 2 to display the data from database 1

              Refrence > Title
              Date > Date

              database 2 is an external data source where i would like to display the date from database 1.
              i have tried all diffrent kinds of relationships. both databases are showing up in each others but they will not interact when called upon :(
              please help ???









              • 4. Re: Database Relashionships ???
                comment_1
                  

                I am getting a little confused by your terminlogy. I suggest you use the term "file" when you mean file, and "table" when you mean table, instead of the generic "database" (which could be anything). Some meaningful names would also help.

                 


                nathan_george69 wrote:
                How do i get the database 2 to display the data from database 1

                Refrence > Title
                Date > Date

                By defining a relationship using exactly those predicates.

                 

                After adding the table from the other file onto the relationship graph, define a relationship between the local table and the one you have just added, using exactly the predicates you have stated.

                 

                Then add a portal to a layout of the local table, showing records from the external table.