Newbie: creating initial relational database
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?