I need this done in visual basic, if you could please also include the GUI design that would be awesome. The studio table and video table is actually an access database. I posted this previously but it was not correct and incomplete. Thank you for your help.

1. Create a Windows application to display the information from the Studio table in the VBVideo.mdf (see screenshots) database file from the StudentData folder on the text Web site. Allow the user to select the studio name from a sorted drop-downlist and display the rest of the fields in labels.

2. Create a Windows application to display the Studio table in a grid.

Studio Table:

Video Table:

Here is the design that I have so far: