alvingenius
IT Specialist
- Local time
- Today, 06:17
- Joined
- Jul 10, 2016
- Messages
- 169
Hello Guys,
I've 2 tables
Table for User Profile ( Name, Date of birth, address, phone, email,...etc )
and table named " Files " that saves file paths of ID Photo, Passport image, Certificates images ( i know its local file paths !) - All Files in PDF extention
and report only showing user profile information and if I print this report it will print every user on a new page.
So, i want to print every user page following with ID and Passport only Photos linked to the user
( Without Certificate - Based on fType or Filename [file name renamed based on type] )
Is this possible?
Attached a sample of DB
Thanks.
Edit1 :
Solution at this post thanks to theDBguy
I've 2 tables
Table for User Profile ( Name, Date of birth, address, phone, email,...etc )
and table named " Files " that saves file paths of ID Photo, Passport image, Certificates images ( i know its local file paths !) - All Files in PDF extention
and report only showing user profile information and if I print this report it will print every user on a new page.
So, i want to print every user page following with ID and Passport only Photos linked to the user
( Without Certificate - Based on fType or Filename [file name renamed based on type] )
Is this possible?
Attached a sample of DB
Thanks.
Edit1 :
Solution at this post thanks to theDBguy
Attachments
Last edited: