0 Replies Latest reply on Feb 6, 2015 12:21 AM by VanessaAnne

    Creating database suggestions



      Creating database suggestions


      I have used filemaker for years but its been a while.  I'm using Filemaker 12.

      I am creating a database from scratch.  I tried using a start up solution but I had trouble figuring out the relationships as it related to my specific project.  I was using the Estimating Starter Solution. 

      I am trying to create a company timeline spend database.  The variables are:

       - companies that have multiple branches (same company has LA, NY, Canada branches)

       - the project title (not every vendor is on every project)

      - how much each company will be paid on the project over the course of 2015 - 2016 by quarterly spend.  

      For example:

      Company A (based in LA and NYC), is getting paid on Project 1 in Qrt1 - 2015 and Qtr2 - 2015.  

      Company A (based in LA and NYC), is getting paid on Project 2 in Qtr 4- 2014 and Qtr1 - 2015. 

      Company B (based in LA and CAN and UK), is getting paid on Project 1 in Qtr 3 - 2015 and Qtr4 - 2015. 


      And so on.  The reports will mostly be a timeline over 2014-2016 lumped by project and schedule on the x-axis, and the company name/location on the y axis.  

      I'm having trouble figuring out how to set up these relationships.  I think portals will be easy for this kind of timeline but should I separate tables by vendor and project and time? 

      Attached is an example. Even advice on which starter solution might be best would be helpful.  

      Thank you.