So, other than an error I'm getting right now with the registration form which is in another thread already, I have my registration form and new project form already set up. I also have the database schema created with the relations noted in the attached image.
The purpose of the new project form is for my clients to be able to start a new project. I have it set up on registration and it will be accessed via their client page. Where I'm getting the error at this early stage is when I press next on the form. It tells me:
"Cannot add or update a child row: a foreign key constraint fails (`zonapromo/Projects`, CONSTRAINT `fk_Projects_Clients1` FOREIGN KEY (`Clients_IDclient`) REFERENCES `Clients` (`IDclient`) ON DELETE NO ACTION ON UPDATE NO ACTION)"
Which I interpret to be the unavailability of a client id which should come from the client table and passed on to the projects table as shown in the image.
I'm just not sure how I would go about this. I'm just starting to play around with database and am not sure if I need a session behavior that would keep the client id at hand and then pass it on as we move along, as well as the project id and any other information that needs to be passed along from table to table.
Any suggestions, pointers or tutorials I should read?