I've created a GUI for a hospital visitor system to allow visitors to find patients based on surname. I've also made a table in access with patient names, surnames, date of birth, gender, ward, rooms, etc. I'm trying to figure out a way to connect to the table, and to retrieve patient details into JTextFields based on a search of a patient's surname. Any help greatly appreciated. Thanks in advance.