I would like to create a form or report and link pics rather than imbedding them. I'm trying to create a query where I can put in a set of parameters which will have some set of output. However rather than embedding pics, I'd like to somehow link the pics. I have some understanding of how to do it, but I'm not totally clear.
I'd like to store some pics in a folder and then in a relevant cell in a row I'd like to refer to that pic via a variable in that cell. That way when I print out the report the relavent pic's show up. I think I know the theory, but I'm not sure if I'm correct in going about doing it. I know this is done in many we pages and it uses such language such as sql and php, but I'd like to use MS access reports or forms instead. Might anyone be able to help? Thanks.