professional database advice [* Resolved *]

[steve_rm]

Hello,

I am developing a database application. I have one form which contains students' details. I can add, delete, and update the records in the form without any problems.

My question is, when l add a new student, should l have new add student form shows, which is the form that allows the user to enter the details. Once the user has entered the details they will confirm the details are correct than press ok. the Text boxes on the add new student form will then be copied to the main student form, and then the update code would be executed.

Is this a professional way to do this, or should l just add the new record in the main form.

I am using C#, but I don't think that matters as this is just a standard database application that could be written in any language.


A second question, should l lock the text boxes when the user is just browsing through the records, and only unlock them when the user wants to update or add new.

Thanks for your professional advice,

Steve