I have a form in vb.net that contains textbox as ID, Name, Age, Sex, Hb, BG.
in database access i have 2 tables as Table1 and Table2.
The Table1 contains ID,Name,Age,Sex and Hb.
The Table2 contains ID,Name,Age,Sex and BG.
I want to save data as ID,Name,Age,Sex, BG to table2 only when i enter any value into textbox "BG" along with other textbox values.
Otherwise it will be saved in Table1 as ID,Name,Age,Sex,Hb when i enter Hb value alon with other textbox values.
And when i enter both Hb and BG value, both tables will save respective data.
So please help me with code.