I want a two tables in an access database. They are 1. a student table with information regarding students along with a markingID field. 2. a marking table with a markingID primary field and module1...module12 marks. I want to create a form using data binding techniques that will display all the marks in the fields module1...module12 when entering/choosing the studentID combo box.

I also want to add a textbox asking the user to enter a student name and the name to be highlighted in the datagrid. Is that possible in data binding.

Also in registering student, I want the StudentID primary key field to automatically increment by 1 when clicking on new in the Binding Navigator. Remember i am working in Access.

Thank you very much.

Nicolas MARIE.