Best form set up?? Not sure how to set this up

[MartinaL]

I need to set up a form that shows the course competencies that a person has completed.

I want a drop down list at the top of the form that is a lsit of all the Courses, when a course is selected I then want the following to be displayed (in datagrid views or whatever anyone thinks will best suit my needs)

Competency Category name
Competency Name | Completed | Completed Date
Competency Name | Completed | Completed Date
Competency Name | Completed | Completed Date
Competency Category Name 2
Competency Name | Completed | Completed Date
Competency Name | Completed | Completed Date

So there are Courses, which contain Categorys (could be any number of categories in each course) and then in each category there are competencies that need to be completed (there could be any number of competencies in each category).

Any ideas??

I have attached the ER diagram of my database in the hope that it will help explain, you can disregard the tables not relating to either courses or cadets.

Only the Categories should be shown that are for the Course selected from the drop down list

 

[cjard]

When you click Save, the TableAdapter's Update() method is called and the datatable is passed as a parameter. The update method scans the datatable looking for any changes (DataRowState of Added, Modified or Deleted) and uses the relevant INSERT, UPDATE or DELETE query lodged in the TableAdapter to send the change. So long as your user has changed something, it will be saved. If they changed 2 things, both changes will be persisted.

YOu can delete the binding navigator and code the bits yourself...