Priya8 says:
I want to store Values in two table in database..
For Ex.
table 1-- Resi
if Resi is clicked then the values are stored in resi_db and then it will also get store in the HEG01_db table in database..
table 2-- NonResi
if NonResi is clicked then the values are stored in NonResi_db and then it will also get store in the HEG01_db table in database..
Can you explain properly the database details and table details where it belongs.
It’s make confusion in your question about tables and database.
table 1 – Resi
“resi_db”
“HEG01_db”
----------------------------------------------------------
table 2-- NonResi
“NonResi_db”
“HEG01_db”
Is Resi , NonResi is its table or value for selection?
“resi_db” , “NonResi_db” and “HEG01_db” It’s also tables?
and all table in same database or in different database?
----------------------------------------------------------
Other than this if you have table as resi_db for “Resi” , NonResi_db for NonResi
and other table as “HEG01_db” then do one think pass values which you want to store in related table also match the type where you can check the value you selected as Resi or NonResi depending on that store in table resi_db or NonResi_db and second table HEG01_db insert script make outside which will always get saved.
It depend on How your saving logic is