I am writting in 8.5 against a progress data base. My main report totals CashReceipts based on posting date. Report is grouped on CustomerID.
i.e.
123456(CustomerID)
ReferenceID CashReceived ItemType
9001 500 Inv
9025 50 CAdj
9035 10 WriteOff
440
This reports tells me the total amount the customer has paid (440).
The referenceID field is representative of transactions that have taken place against a jobs. For instance ReferenceID 9001 and 9035 belong to a job with a number 23541, whereas ReferenceID 9025 belongs to job 55555.
The job information is in another table. (Subreport)
ReferenceID JobNo Job Description
9001 23541 Cards
9035 23541 Cards
9025 55555 Paper
The only link to the job info is the ReferenceID. If I select from the job table with reference ID I get multiple hits on the customer. How can I select the job info uniquely?
i.e.
123456(CustomerID)
ReferenceID CashReceived ItemType
9001 500 Inv
9025 50 CAdj
9035 10 WriteOff
440
This reports tells me the total amount the customer has paid (440).
The referenceID field is representative of transactions that have taken place against a jobs. For instance ReferenceID 9001 and 9035 belong to a job with a number 23541, whereas ReferenceID 9025 belongs to job 55555.
The job information is in another table. (Subreport)
ReferenceID JobNo Job Description
9001 23541 Cards
9035 23541 Cards
9025 55555 Paper
The only link to the job info is the ReferenceID. If I select from the job table with reference ID I get multiple hits on the customer. How can I select the job info uniquely?