More learning errors I think
(I walked away from this thing for a couple of months and now I'm so lost)
I have relationships set up 2 different ways and I cant figure out why, or what is right.
In the image below I have tbl_houses and tbl_housetype
and I have linked the "housetypeID" to "housetypeID"
I also have tbl_transactions and tbl_TransactionType
but in this scenario I have linked "TransTypeID" to "transType"
can someone help me understand the difference here and what is the proper way??
Thank you