I am able to do this in Access, but have never don a Join in SQL,.
I want to create a One to Many Join Table.
I want to setup a User with many Accounts that relate to him.
I will give you the Tables that I am using:
HC_HeadCount_Main: This will hold the User’s Information
HC_Leverage_Accounts : This table will hold the Many different Leverage Account for the User in the HC_HeadCount_Main table.
FK: HeadCountID : Not Sure if i made the FK corrently
I want to make sure to setup the "Referential Integrity" so to make sure when i delete or update the Parent Row the Child Rows get updated as well.