AnsweredAssumed Answered

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

Question asked by makita on Feb 12, 2009
Latest reply on Feb 23, 2009 by 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.  

      

Outcomes