GUIDO22
Registered User.
- Local time
- Today, 06:53
- Joined
- Nov 2, 2003
- Messages
- 515
Hi
I have a database application that records production times against a jobnumber.
During production time if an employee makes a c@*k up - the remedial work is booked to a REWORK id. This id is mapped to the original jobnumber.
The problem I have is at report time. My report has a sub-report that retrieves all relevant information for a particular jobnumber, but I also need to retrieve any rework time booked to the job as well.
This rework time has been booked in a seperate database table - how can I display this information within the same sub-report and NOT use a UNION query (which I have tried but proves to be slow and doesnt quite work anyway because the parent report only returns a match for the jobnumber alone (and not the assoicated rework id/ids....????
Any ideas please people?
THanks
Guido
I have a database application that records production times against a jobnumber.
During production time if an employee makes a c@*k up - the remedial work is booked to a REWORK id. This id is mapped to the original jobnumber.
The problem I have is at report time. My report has a sub-report that retrieves all relevant information for a particular jobnumber, but I also need to retrieve any rework time booked to the job as well.
This rework time has been booked in a seperate database table - how can I display this information within the same sub-report and NOT use a UNION query (which I have tried but proves to be slow and doesnt quite work anyway because the parent report only returns a match for the jobnumber alone (and not the assoicated rework id/ids....????
Any ideas please people?
THanks
Guido
