6 Replies Latest reply on Dec 2, 2008 7:14 PM by mayor

    View data from 2 tables in 1 Layout.

    mayor

      Title

      View data from 2 tables in 1 Layout.

      Post

      Hello,

       

      I have designed 2 tables and have problem in dispalying the data. How to make 1 form that can view data from 2 tables.

       

      TQ

        • 1. Re: View data from 2 tables in 1 Layout.
          davidhead
            

          You really have to provide more details to get help.

           

          What are the two tables you have and what do you want to display on the layout? 

          • 2. Re: View data from 2 tables in 1 Layout.
            mayor
              

            I got 2 tables : vot and expenses

             

            field in vot :

            year

            vot_no

            vot_amount

            total_expenses etc

             

            fields in expenses:

            po_no

            po_date

            po_amount

            staff_name

            supplier

            date

            do_no

            do_date

            invoice_no etc.

             

            Relationship : I'm using 2 fields which is year & vot_no

             

            I have created 1 layout to display :

            po_no

            po_date

            po_amount

            staff_name

            supplier

            date

            do_no

            do_date

            invoice_no etc.

             

            together with

             

            year

            vot_no

            vot_amount

            total_expenses  

             

            which are in different table. So how to do that. I have tried but only

            data from 1 table are displayed (table expenses)

             

            TQ

            • 3. Re: View data from 2 tables in 1 Layout.
              TSGal

              mayor:

               

              Thank you for your post.

               

              Go into the Relationships graph in "Manage -> Database", and make sure the "year" and "vot_no" fields in "vot" table are linked to the proper two fields in "expenses".  Once that is set up, you should be able to view the data properly in the current layout.

               

              Make sure the values are the same in both tables.  Otherwise, the link may not link to the other table, and therefore, only information from the current table will display.

               

              TSGal

              FileMaker, Inc. 

              • 4. Re: View data from 2 tables in 1 Layout.
                davidhead
                  


                Relationship : I'm using 2 fields which is year & vot_no

                 


                If those two fields are from the vot table, which fields are they matched to in the expenses table? 

                 


                • 5. Re: View data from 2 tables in 1 Layout.
                  mayor
                    

                  Thank you for your reply, I got the idea. Now, data from 2 tables can be view in one layout but in different manner, not simoultenously. Meaning that, data from table expenses is display first and when I enter vot_no, then data from table year is displayed.

                   

                  table expenses

                  po_no

                  po_date

                  po_amount

                  staff_name

                  supplier

                  date

                  do_no

                  do_date

                  invoice_no etc.

                   

                  together with

                   

                  table year

                  vot_no

                  vot_amount

                  total_expenses  

                   

                  How to get it display at one time?

                   

                  TQ

                  • 6. Re: View data from 2 tables in 1 Layout.
                    mayor
                      

                    I'm using same fields name for relationship in 2 tables, like below:

                     

                    vot table

                    vot_no

                    year

                     

                    expenses table

                    vot_no

                    year