InstructionWhich7142
Registered User.
- Local time
- Today, 22:51
- Joined
- Feb 24, 2010
- Messages
- 199
I have data in two tables like:
and
and I want the report to show this in the detail:
instead of how a query would normally give: (without using two queries and two subreports in the detail band (because they're memo fields and growing gets tricky))
is this possible with queries at all? I wondered about doing a Union but then I may as well just use two queries and two subreports instead of the union
ID | ParentID | Value |
---|---|---|
16 | ID6 | 1 |
17 | ID6 | 2 |
18 | ID6 | 3 |
and
ID | ParentID | Code |
---|---|---|
35 | ID6 | A |
36 | ID6 | B |
and I want the report to show this in the detail:
ParentID | Value | Code |
---|---|---|
ID6 | 1 | A |
ID6 | 2 | B |
ID6 | 3 |
instead of how a query would normally give: (without using two queries and two subreports in the detail band (because they're memo fields and growing gets tricky))
ParentID | Value | Code |
---|---|---|
ID6 | 1 | A |
ID6 | 1 | B |
ID6 | 2 | A |
ID6 | 2 | B |
ID6 | 3 | A |
ID6 | 3 | B |
is this possible with queries at all? I wondered about doing a Union but then I may as well just use two queries and two subreports instead of the union
Last edited: