AnsweredAssumed Answered

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

Question asked by GREGORYNELSON on Feb 9, 2014
Latest reply on Feb 10, 2014 by 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.

Outcomes