Use listbox with SQL table data to fill remaining form controls upon selection

IronDriver,

You understand that what you are asking needs a lot of code to do. I will show you the basics and you can start working with that but it's difficult to explain everything in a post. I will show you how to retrive data from the form and populate the listbox (in the example I use a listview) but you can use that. Check this example that I post it yesterday https://www.experts-exchange.com/questions/23111538/Show-Search-Results-In-Windows-Application-Form.html

Then what you have to do is when the user change the selection on the listview (listview selectedindexchange event) you read again from the db and populate the textboxes.

You can also use a datagridview control and bind using the available wizards. With this you can update/delete and insert direcly in the datagridview.

Thank you jp for the response...sorry so long to follow up. It has taken me a little while to actually get this to work as you have referenced in some of your prior comments. I have gotten the listview to work fine but that is about half the battle. I have included a diagram in PDF format the better illustrates what I am looking for. I may be headed about this in the wrong manner and if so feel free to let me know a simpler way...or if I am just wayyyyy off.   Thanks!
Simple-Table-Diagram.pdf