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

[invitro]

In my opinion its better to pop open a new form and allow the user to add information inside of this new window. It is less confusing this way, and it will only show when nessecary. Having the add option in the main window would make it more cluttered.

As for locking text boxes, I would say no. If I were to browse through a 100 records I needed to change 1 thing on, I really woulden't want to click the Unlock button in order to have the ability to change something. You want things done on the fly rather then introducing an extra step.

my .02

[steve_rm]

Thanks for your advice

Steve