Thanks for the help- a couple points of clarification:
- Correct me if i'm wrong and I must be, but I thought the purpose of a foreign key is that it should populate itself based primary key in the connecting table? Also when i try and insert rows into the foreign ID columns i get an error conflicting with the foreign key constraints
-When i try and insert values for all columns i get an error conflicting with foreign key constraints when i try and insert values into all the columns, and it was my understanding that those columns would auto-fill based on the primary key in the connecting table.