HI
I am using Php and Mysql for an employee database.I have normalized the tables.Now through the form i enter the details which is going to different tables.I have a problem here ie,In each table the primary key from the Master table is kept as the foreign key in the transcation tables.So in the same form i have to enter the same foreign key field each time.Is there any Options for entering the Id only once through the form. Also How can i move the details to each table finally the submit button is clicked.How the insert statement works here?ANyone plz help
thanks in advance
I am using Php and Mysql for an employee database.I have normalized the tables.Now through the form i enter the details which is going to different tables.I have a problem here ie,In each table the primary key from the Master table is kept as the foreign key in the transcation tables.So in the same form i have to enter the same foreign key field each time.Is there any Options for entering the Id only once through the form. Also How can i move the details to each table finally the submit button is clicked.How the insert statement works here?ANyone plz help
thanks in advance
Comment