Member Avatar for nicolasmarie

Hi,
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.

  • 2 Contributors
  • 1 Reply
  • 91 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
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.