Insert records from one table to another

[vrk1219]

Hi,
I have a form where the user enters some values that gets stored in a table, which on closure of the form should be inserted into another master table.

Please tell me how I can do it?

Regards
RK Veluvali

 

[hunter_vs]

Hi,
I have a form where the user enters some values that gets stored in a table, which on closure of the form should be inserted into another master table.

Please tell me how I can do it?

Regards
RK Veluvali

you will be breaking the rules of normalization if you do that!

 

[vrk1219]

My temp and the master table are almost mirrors to each other in their design. Instead of giving access to user to enter data directly into the master table I collect data from a form (data entered by suer) into the temp table first, do all validations there and then insert the data into the master, and upon closure of the form I clear all the data in the temp table.

Is this a problem?