3 Replies Latest reply on Feb 10, 2014 3:30 PM by GREGORYNELSON

    Newbie Post - Tables and Fields - How to construct and link correctly

    GREGORYNELSON

      Title

      Newbie Post - Tables and Fields - How to construct and link correctly

      Post

           I cannot wrap my head around the relational aspect of FM13.  I am constructing a database to track 10-12 components of a construction project.  We will use this db over our network with 4 users.  

           The principal table is Projects, in that table is a field called ProjectNumber that contains the number we have given that particular project, it is a text field.  We also have a table called ChangeOrders that will be linked to project with a foreign key.  My question is do we have to have a field in ChangeOrders also called ProjectNumber so FM will know the relationship between the two, or do we use the Projects table's field as a value list to link the two?  This concept would also apply to any other parent/child table relationships we have in the db.