Hi do any one know how to add info into two table.
I hava a page call add page it will add the info into one of the two table base on the active account or non active account ?

Do anyone know use what method to do it using the VB 6 ?

One table at a time. First Parent table then child table records. You can use the .AddNew method if you have a seperate rs for each table or use an insert into statement and execute it with the command object.


Good Luck