Member Avatar for 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..

  • 3 Contributors
  • 3 Replies
  • 135 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by jbennet
Member Avatar for jbennet

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

Please consult the rules.

What language is this? moved to c#

Member Avatar for jbennet

will ask for it to be moved

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.