11 Replies Latest reply on Feb 23, 2009 11:08 AM by makita

    HELP...Newish user trying to set up many-to-many database...I'm going in circles !

    makita

      Title

      HELP...Newish user trying to set up many-to-many database...I'm going in circles !

      Post

      I know that Filemaker is the right solution for my database, but I have not used FM since 1996 and am having some trouble figuring out the concept of JOIN TABLES and PORTALS

       

       

      I need to track the following in regards to HERBAL SOLUTIONS

       

       

      PROGRAMS -- Each Program consists of several FORMULAS

       

      FORMULAS -- Each FORMULA consists of several BOTANICALS

       

      BOTANICALS -- Each BOTANICAL has several THERAPEUTIC USES

       

      THERAPEUTIC USES -- Each THERAPEUTIC USE has several SOURCES

       

      SOURCES -- For each SOURCE I need to track:  (A) SOURCE NAME (a book, organization, or website)        

                                                                       (B) SOURCE REFERENCE (page #s or specific URL)

                                                                       (C) SOURCE DATA (a jpeg or pdf) 

       

       

      I believe I set up:

       

      Table

        PROGRAMS:  Fields -- Program ID and Program Name

       

      Table

        FORMULAS:  Fields --  Formula ID and Formula Name

       

      Table

         BOTANICALS:  Fields -- Botanical ID and Botanical Name

       

      Table

        THERAPEUTIC USES:  Fields -- Therapeutic ID and Therapeutic Description

       

      Table

        SOURCES:  Fields -- Source ID and Source Name and Source Reference and Source Data

       

       

      I don't know how to set up the JOIN TABLES or how to use PORTALS to link the information.

       

      Any help would be soooooooooo appreciated.