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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.