I have an SQL table, (tblFPDetail), that I would like to retrive data from and display this information in several textboxes on my form. My table has a foreign key (PCIDNum) with another table,(PCinfo). The PCInfo table contains a field, PCName. I would like to be able on my form to have a listbox that shows the PCName values of which the user would select the appropriate one. The remaining textboxes on the form would then fill with the related data from tblFPDetail. The user should then be able modify the values within the textboxes with data from tblFPDetail and select save from the toolstrip and have the values within tblFPDetail be modified.
Thanks in advance for any help!