>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...