M
Mark J
Guest
I'm working with a database that gets the majority of it's data via ODBC links. I've created a form that is an information page that draws from a half dozen tables in a single query. As I bring up each new record in the form, I need to bring in a picture of the individual whose info is displayed.
The field "ImageFileName' is part of my query. How do I get Access to go get the proper Image that matches the current record displayed? I have the image table linked in the query by: SSN, so that should be all set. Another issue is that some SSN's have multiple photos on file. I'd like to have the ability to tab through each photo for each SSN.
The field "ImageFileName' is part of my query. How do I get Access to go get the proper Image that matches the current record displayed? I have the image table linked in the query by: SSN, so that should be all set. Another issue is that some SSN's have multiple photos on file. I'd like to have the ability to tab through each photo for each SSN.