Displaying data from Access DB in C# Program
Over the past few days I have been working on what is essentially an access database viewer but have run into many problems. I have accomplished listing Names in a combo box but have an interesting situation. The particular database I have to work off of (there are many many others structured the same way) has multiple entries of the same name but is linked to a differant image file, for ex:
Name SSN Image File
Joe Somebody 123-12-123 someimage1.tiff
Joe Somebody 123-12-123 someimage2.tiff
Billy Bob 456-45-456 someimage3.tiff
Billy Bob 456-45-456 someimage4.tiff
You get the idea...
Anyway, i have the Name and SSN displayed in a combo box but am getting duplicate entries for each person because the same name spans across multiple rows. I have searched through MSDN and google to no avail while trying to get unique records to show in the combo box. Another problem I am facing is that this certain database stores the path to the image in a seperate table and I am unable to find any information on using one query to felect data from multiple tables (is this possible?). I have also tried to make a 2nd query but was unsuccessful.
If anyone has answers to any of the questions/problems above I would greatly appreciate your help.