Hi guys, Its been a while since I posted last message, but here I am again...
I recently started to move from VFP8 to VFP9. One of the benefits is famous multi detail bands with which I am having a problem. Its a VFP9 SP1 app that do some interest calculation and should have a report that has two detail bands. First details band is from cursor that holds data about financial data: lists of unpaid invoices with their amounts, dates and description and lists of amounts paid with appropriate details. Second details band is actual interest calculation based on previous amounts overdue and amounts (if any) paid. VFP help says that I should have some relation between two or more detail bands that is based on driving alias (main table or table listed in initial selected alias) and target alias that represents other tables (cursors) related to that main table. Well I don't have real relation between these cursors its not like invoice header - details case, there is no primary or foreign key in them. Actually I get some results but they are not what I want to get. Instead of getting printed all first details band and then all second details band I get intermingled records and that is unacceptable. So what do I do and how? Regards Zed --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

