View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

How to go about doing this?

Thread began 11/09/2009 7:52 pm by jc1cell390254 | Last modified 11/18/2009 6:06 pm by jc1cell390254 | 1529 views | 8 replies


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?


Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...