One form data to be inserted/updated into multiple tables

[wnmichaud]

Help Me, Please..VERY URGENT

I have this cenario:

I have a form(NewcomplaintForm.vb that will collect informations for ComplaintTable(complaintid, ComplaintType, date, desc, status, recommendation, etc..); ComplainantTable(complainantid, last, first, etc..); OffenderTable(offenderid, last, first, etc..) DutyofficerTable(dutyofficerid, last, first, etc..) and insert data into these tables respectively.

when NewComplaint, check for complainant last and first name and identication, if they exist, update/modify and create a NewComplaint document. if not exist, create NewComplaint document.

I create the form in visual studio 2005, table in sql express..
I create a data set meaning 4 datasets since i have 4 tables..
I drag these dataset into the form..

Now I cannot get the insertion part done nor update nor checking for the complainant info before any new complaint create.

I need to accomplish the following:

1) CREATE A NEW COMPLAINT AND PRINT IT
2) SEARCH FOR A COMPLAINT BASED ON COMPLAINTID OR COMPLAINANTID, OFFENDERID

3) NEED TO MAKE THESE DATASETS WORK SO I CAN INSERT/UPDATE INTO THE TABLES

4) NEED TO HAVE COMPLAINTID SYSTEM DRIVEN

5) A COMPLAINANT CAN HAVE MULTIPLE COMPLAINTS

6) AN OFFENDER CAN HAVE MULTIPLE COMPLAINTS ON THEM

7) KEEP TRACK ON COMPLAINT STATUS AND RECOMMENDATION.

Please give me step by steps to get this done..
I am very new in this..

I Can be emaiedl at <snip>

THANKS A LOT IN ADVANCE!!!!!

I'm standing by for a reply..

[jbennet]

1) this isnt an introduction
2) dont post your email address here.

Please consult the rules.

What language is this? moved to c#

[ddanbe]

NewcomplaintForm.vb ----> Visual Basic? ----> VB.NET

[jbennet]

will ask for it to be moved