Having problem w/ Mutiple queries in report [message #159995] |
Wed, 22 February 2006 09:58 |
sikorsky05
Messages: 40 Registered: October 2005
|
Member |
|
|
I am having difculty displaying data in a report...
1st Query is
Select unique(f.fmc),f.model,f.S_DESC FAIL_MODE_DESC,c.s_desc CA_DESC_SHORT
from fail_mode f,fm_ca c
where f.fmc = c.fmc
and f.model = :model
and c.model = :model
order by f.fmc
Return data will be
FMC MODEL FAIL_MODE_DESC
1 UH60M desc.
2 UH60M desc.
3 UH60M desc.
2nd query
Select MODEL,FMC,DOC_SEQ from fm_ca_doc
where model = :model
order by doc_seq
Returned Data will show
Model FMC Doc_Seq
UH60M 1 1
UH60M 1 2
UH60M 1 3
UH60M 1 4
UH60M 2 1
UH60M 2 2
UH60M 3 1
UH60M 3 2
UH60M 3 3
When I add datalink from query 1 - query 2, I am joining
FMC & Model...
When I build the report I get FMC but not the correct doc_seq associated w/ the FMC...
How can I fix this ... I have one to many relationship and the information is not displaying properly.
Any suggestions
|
|
|