I have created two tables one for long term goals (tableA) and one for short term goals (tableB)
Each table has its own PK but in tableB I store the PK of tableA for linking the two tables. The relationship is for each long term goal you can have many short term goals to achieve the long...