2 Replies Latest reply on Jun 13, 2017 8:46 AM by Jaymo

    Relaed Tables

    rmycholuk

      Good Morning Everyone,

       

      We are transitioning from access to filemaker to track our daily payments for incoming membership and non-membership revenue. I am struggling to create through tables and/or scripts the following relationships and hoping someone can help me. Our fields are as follows.

       

      Payment Type > Invoice Number > Name > Anniversary Month > Total Paid

       

      What I want to happen is if someone selects one of 5 payment types in that field (New, Renewal, Directory, Online) only the corresponding amounts that it could be appear in Total Paid (1, 2, 3, 4) or if a different previous selection occured (5, 6, 7, 8)

       

      Everytime I try I create it incorrectly removes all my tables. Thanks,

        • 1. Re: Relaed Tables
          planteg

          Hi,

           

          the tables in FileMaker could be much the same they are in Access. One important thing you should understand in FileMaker is the difference between a Table and a Table Occurrence.

           

          The table is the container that holds the data (same as Access).

           

          The Table Occurrence, that you find in the Relationship Diagram is the representation of a Table. For someone with an Access background, this is how I explain it:

           

          think about creating a query in Access. You can directly create the SQL Query by typing 'SELECT column1 FROM Tablex...' Or you can create it graphically by dragging tables and linking fields for the WHERE. The Table Occurrence are the same.

           

          In FileMaker, you can't define relations at the Tables level, only at the Layout (Form) level. This is why a Layout is always linked to a TO.

           

          HTH

          • 2. Re: Relaed Tables
            Jaymo

            Sounds like you need a conditional menu. Conditional menus are based on relationships so you can displays a subset of values in a popup menu rather than all of them. Attached is an example of the Value List dialog with a conditional menu specified.