dr_move wrote:
g "a" record of when I select a picture,
"B" when I select a record in b shows a picture of you.
You need to make Identification Card ID and Picture ID unique. The database design should be such that, any one value supplied can fetch all the other information related to it.
Create two queries, one based on Card ID, other on Picture ID. Based on available parameter, use the respective query and show it in the report.