Newbie Post - Tables and Fields - How to construct and link correctly
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.