Linking tables in Sql Server database using VB

I have a two forms each one accessing data from a table in
a SQL server. How do I link the two tables using VB such that when I add a record in one, the other table is also updated.

[paulw]

Once you have posted the update in form1, use the refresh (or requery) method on form2 dataset.

P.