Hi, I have a project that I’ve been trying to do for months and months on my own, but it has got to the point where I can’t carry on because I’m so stuck, and all the tuts I try to follow don’t work for what I need.
I am trying to create a program that keeps account of clothing that is lent to a certain person in the cadet force. So for example….
User walks in and asks for a combat jacket > *program loads up onto a form that holds a datagrid view and displays all the members. The assistant selects the users account from the datagrid viewer and clicks a button saying ‘select’. The program then loads the information that is held in a table called tblClothing into labels and textboxs etc saying what they have. I.e: Combat Jacket is loaded into a label, ‘2’ is loaded into a numerical box to say they have 2 combat jackets issued, and a check box is checked to say the item has been issued but not returned.* > we find a correct combat jacket and give it to the user who then goes. > *back in the program the numerical box is updated to ‘3’ by the assistant so we now know that 3 combat jackets have been issued to that user and if we do not have 3 returned then we can charge them for the loss. The assistant then clicks the ‘save button’ and the updated information is saved back into the database.*
I know that all seems very complicated but when you actually think about it not much actually happens. Below is a picture of what I imagine the database structure and relationships to look like but could you please tell me any recommendations you have for me to change it.
Ok so presuming the database is good, the next help I need is linking that database into the form. I understand how to get it to show in the datagrid view but I do not know how to select a row and load it’s separate cells into textboxs etc….
Thanks for any help, it’s all appreciated….please try to help
I have also attached my soloution so if you want to d/l and see what i imagine for myself please do. It should help you understand better. Thanks