need a database application in vb.net, to connect to an sql database in a network enviroment, the application is for a medical office,
1- need login feature for employess
2- patient dempgraphics
3- patient history for notes purposes- pre visits, etc..
4- Patient monitoring time, it monitors how long the patient is been waiting to see the doctor, also how long patient sat with the doctor, upon patient arrival , front desk enter patient info, and then assigns it to doctor, and the clock starts counting, once patient enters to see the doctor, new clock starts, records are stored for reports upone requests,
more feauteres, such as graphical labels that will display the patient name with the clock incrementing. and once patient is waiting more than 30 min, lable starts blinking etc..
I need tutorial on how to customize the code, ost important if u r able to show me the databse conenction that can be modified at runtime, also need help setting the relationship in the database, ex. patient tables one to many patienty visits with notes, etc..