HELP...Newish user trying to set up many-to-many database...I'm going in circles !
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:
PROGRAMS: Fields -- Program ID and Program Name
FORMULAS: Fields -- Formula ID and Formula Name
BOTANICALS: Fields -- Botanical ID and Botanical Name
THERAPEUTIC USES: Fields -- Therapeutic ID and Therapeutic Description
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.