Insert to a link table via two seperate tables

[ArunaJo]

Hi,

I have two tables(Invoice, Item) in sql server 2008

Table Invoice
InvNo PK
InvDate

Table Item
ItemId PK
ItemDescription

Table InvoiceItem
InvNo FK
ItemID FK

I want to know how to get the link table updated when seperately entering data to the main tables(Invoice, Item)

Can you give me the stored procedure
and the coding in vb.net for the forms

Tx
AJ

[zmbd]

Can you show us what you've tried so far?