AnsweredAssumed Answered

Newbie: creating initial relational database

Question asked by FawnHill on Nov 1, 2011
Latest reply on Nov 14, 2011 by philmodjunk

Title

Newbie: creating initial relational database

Post

I am new to relational database setup and I am trying to figure out how to set up a test case database in filemaker.

See attached image -- I figure that I will need a main table to contain records of each of the test cases -- new test cases will be added as time goes on.  I believe I would then have an additional table for each new project which would contain a subset of applicable test cases, but each test case record in the project table would also contain results information for the test case in that particular project -- the results and other fields will be different for each of the projects, but the test cases themselves would not change, unless the main test case is changed.  How would I initially set this up?

test_cases.PNG

Outcomes