4 Replies Latest reply on Sep 10, 2014 4:40 PM by digitalemu

    Table Creation / Setup Advice...

    digitalemu

      Title

      Table Creation / Setup Advice...

      Post

      Hiya guys. 
      This is not a Filemaker Specific advice request, more a general advice on DB solutions.. 

      My main tables are : 
      Customers, Jobs, Appointments and Opportunities. 

      All four of these tables require a table to store related files... I.E : Job completion certificates, Opportunity Photographs, Customer Logos and Appointment Attachments.. etc. 

      My question is this; 

      Am I better off with Example A:
      Creating just one "Files" table to hold data for all tables and simply creating new occurrences of the Files table for each other table... 
      OR
      Example B: 
      Should I create an individual Files table for each parent table. 
      I.E : Customer Files, Job files, Opportunity files and Appointment files? 

      Container data is going to be stored externally. 


      Thanks in advance guys. 
      Jamie. 

      DBCompatiosn.jpg