0 Replies Latest reply on Apr 8, 2013 10:30 AM by StevenZangwill

    Need help with database structure

    StevenZangwill

      Title

      Need help with database structure

      Post

           I need to build a basic database to manage a multi-institutional research trial. The needs are rather simple as we will use a separate product for data warehousing and analysis. I need to allow centers to login to my filemaker solution via the web, enter coded data for study patients and then for each patient, fill out numerous simple dataforms with each form being associated with a unique sample code. Sample lables will be printed and the samples (blood) will then be shipped to the study center for processing. Just having trouble envisioning the structure at the outset. Is it one file where each study participant has numerous forms and samples associated with them - or do I create two separate files, one for patients and one for forms and samples? Ive done enough database development in the past with filemaker that once I come up with the right structure, I'll be able to run with the rest (I think). Appreciate any thoughts. Thanks