UPDATE-------------------------------------------------------------------------------
I have the foreign keys working that is not really my problem. My real problem is having a auto-increment key that resets for each unique foreign key. I assumed that this would have a composite key configuration.
