Umm_Hasan - 8:01 pm on Mar 10, 2011 (gmt 0)
Thank rocknbil for your reply.
The field is NOT an auto_incremmented field; however, it is a forign key to Registration2011.ID but when I dont put the $pid as a value for the Partners2011 ID column it throws a forign key constraint error.
I'm considering just totally taking out the forign key and auto incrementing the Partners ID field and doing an INSERT INTO level_table (fname, lname) FROM Registrants2011 FirstName, LastName WHERE Level = level (whatever level I need it to insert into based on the users selection) and doing the same for the partners table.
I figured if I did this then for sure the two current tables (Registration2011 and Partners2011) will work just find with what I have taking out the $pid and let the partners ID auto increment BUT, the hesitation is that each Registrant (student) MUST have a Partner (another student) to compete as a team and it is a requirment for this competition.
The logic behind the table is to collect all user input for both the Registrant and their Partner keeping their ID (registration #) the SAME FOR BOTH the Registrant and their Partner and laster query out the selected Levels of participation.