This may finally be it. I have been reading database table structures and I added a necessary field to all of my tables.
Now, I need one last thing and I think everything will work.
I hard coded the RecruiterID into the CandidateCC candidates for a particular recruiter (in this case, 41)
I set up the database according to this new field that is now shared by all tables.
I logged in as the recruiter and WOULDN'T YOU KNOW IT, IT WORKED!
So, I now have to figure out one thing:
Is the RecruiterID automatically put into the RecruiterID field or do I have to copy the RecruiterID from the RecruiterNames table to the CandidateCC table when a Candidate choose the Recruiter's Name?
If I have to copy it, then the php code has to query the RecruiterNames table based on the Recruiter's Name and get the RecruiterID value, right?
Then it needs to write that ID to the RecruiterID field in the CandidateCC table.
If someone could point me in the right direction (I am going to see how to do it in my book, but if anyone knows the answer faster than I can read/hunt for it, I appreciate the help.
Mike