I have an invoice table, which is related to a detail table.
The invoice table is also related to the order entry table.
The order entry table is linked to to tables one is bill codes, the
other is,dept codes
Finally I have a table that is the history of the work being done,
linked to dept codes.
So a simple sketch of relationships
Invoices
|---- Invoice Details
|---- Order Entry
|---- Bill Codes
|----- Department Codes
|----- History Worked
When I do things in the command window, ie browse invoices, I get the
results I expect. If I line up the windows for each table browse so I
can see them all, and pick an invoice all data appears as it should.
Now the fun is I want to create a report from this scenario
ie
At the top would be the invoice and its details
Below that would be the order entry table with its two children
Below that would be the history table
Questions
Is this a multiple detail band report... I've never used them before. If
so, how would I do it? (Hints please)
Also, the simple report of the first query takes a long time to
display... How Can I speed it up?
TIA,
Mike
_______________________________________________
Post Messages to: ProFox@leafe.com
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/4e8b8aad.7050...@golden.net
** 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.
