https://www.linkedin.com/pulse/importance-foreign-key-constraint-tim-miles/
So to this point I really have been calling fields Foreign Keys (FK) but I have not been enforcing it. It is important to understand that you can build a Database without Foreign Keys and it will work, BUT there are things it cannot do
This is a good (short) article explaining why you should have the constriants
So all my tables now need to be modified to add the Foreign Key Constraint, here is an example