Automatic copy from form to another table

[Maailmapoiss]

I have form were users can insert confirmation information and table were is held information about projects.
I need that when users fill's the Confirmation Form then on closing it would copy some values to the Project Table.

 

[Mile-O]

Why? The concept behind a relational database model is that you don't duplicate data anywhere within your database.

If you have to duplicate info then you have a design issue with your table structure meaning that the database is not normalised.

There are hundreds of posts on this topic as it's the biggest mistake made when people build databases.

 

[Maailmapoiss]

The problem occurd, when my boss found a Marketing manager database, where she held information about projects, the new database holds a lot more information, but these two databases have to be joined. From your statment I got an idea maybe how to put them working Thanks