Hi all,
I am really hoping to find some help with vb6 datareport.
I have access database that I access from vb6. And I have the following tables:
Videos:
Videoid, title
Employees:
Empid,empname
Jobs:
Jobid,jobname
Videos_Roles
Autoid,jobid,em pid,videoid
Videos table holds list of videos the company owns. Jobs are possible jobs of the employees. In Videos_roles table, a video is associated with employee and his/her job in that particular video. An employee could be director in one video, cameraman in another or have multiple jobs in one video.
The query works fine and everything is perfect except when reporting.
When customer requests a report of a video, I want to show title of the video and list of all employees who participated in that particular video with their roles. Something like this:
Title: Visting The North
Employee Role
Ferdos Director
Helen Camerman
How can I do that? Anything would be helpful.
I am really hoping to find some help with vb6 datareport.
I have access database that I access from vb6. And I have the following tables:
Videos:
Videoid, title
Employees:
Empid,empname
Jobs:
Jobid,jobname
Videos_Roles
Autoid,jobid,em pid,videoid
Videos table holds list of videos the company owns. Jobs are possible jobs of the employees. In Videos_roles table, a video is associated with employee and his/her job in that particular video. An employee could be director in one video, cameraman in another or have multiple jobs in one video.
The query works fine and everything is perfect except when reporting.
When customer requests a report of a video, I want to show title of the video and list of all employees who participated in that particular video with their roles. Something like this:
Title: Visting The North
Employee Role
Ferdos Director
Helen Camerman
How can I do that? Anything would be helpful.