AnsweredAssumed Answered

Create a report

Question asked by lamp on Oct 29, 2009
Latest reply on Nov 5, 2009 by philmodjunk

Title

Create a report

Post

Dear All,

I have a database with current table ( customer, query, sub-query). 

A customer raise an query we put it in the database any work is done related to that query registers as sub-query. Relation is as follow

 

customer.customerid=query.customerid

query.queryid=subquery.queryid

 

When I want to create a report from "sub-query" I want to list all queries with related sub-query.

for example:

query                 sub-query            

shoping              list the wanted items

shoping              get price from shops

shoping              purchased

 

upsent               holiday

upsent               sickness

upsent               bank holiday

upsent               suspend

 

buy car              search for car

buy car              see car seller

buy car              put a bit

buy car              bought car

 

 

as we can see above there is one query called ( shoping ) it has three sub-query and so on. how can I make my report to look like follow:

 

query                 sub-query            

shoping              list the wanted items

                         get price from shops

                         purchased

 

upsent               holiday

                         sickness

                         bank holiday

                         suspend

 

buy car              search for car

                         see car seller

                         put a bit

                         bought car

 

Please let me know if you need more information or is not clear.

 

Thanks in advance

 

Lamp

 

Outcomes