When to use Dynamic Data Field and When to use Reference?
it is maybe a silly question, but it is taking me a lot of time to design my relational database
and Iām used to visual linking 
This is a very important question and we have a tutorial explaining the same
Basically Reference keeps the reference of the parent item and it anything changes in it, then those changes get reflected across all the items/data where it has been used. In case of dynamic option, we store the values of that item/record at that time and it it not linked to the original data so if something changes in the parent item then those changes are not reflected in the places where it is being used (only value gets copied)
Below is the tutorial
