Hi, i'm new here.
My database contains a table from which the report is generated. Then in another table there are signiture pictures. Table a (report table) links to table b via clerk.
I want to show the picture matching the clerk in the report.
e.g if the report shows clerk 'fred' then picture1 should show, else if the clerk is john then picture2 should show.
I am having problems. When i skim through the reports, it just shows it in the order that table 2 is set up.
I have no problems displaying the pictures in the report.
Can someone help me out please?
My database contains a table from which the report is generated. Then in another table there are signiture pictures. Table a (report table) links to table b via clerk.
I want to show the picture matching the clerk in the report.
e.g if the report shows clerk 'fred' then picture1 should show, else if the clerk is john then picture2 should show.
I am having problems. When i skim through the reports, it just shows it in the order that table 2 is set up.
I have no problems displaying the pictures in the report.
Can someone help me out please?
