>Does anyone know trick to get mutiple detail informAation in a vfp report? I have three tables clients, orders, and contacts. Each client can have mutiable orders and mutible contacts. My customer wants the his to group the clints orders in one section and group the clients contacts in another section. In the past I did this with a cursor and a memo field. Does anyone have a better method?
>
>Thanks
>
>Steven Summers
>
>
>:>
Grab all records into a single table and use an identifer to the type of values key to the level... then do a standard report with simple data grouping controls.

Ex table results...

rectype   clients    orders      contacts
  1       bill       
  2       bill       order 1
  3       bill       order 1     mary
  3       bill       order 1     mark
  1       jane       
  2       jane       order 72 
  3       jane       order 72    judy
  2       jane       order 100
  3       jane       order 100   karen

Hope this sparks more ideas for you...