Creating a data pipeline ordered by another table

rbuser

Hi,
I will try and explain:
I want to have a pipeline which orders the detail on a table by using a
field in the detail which is linked to another table. i.e. I have an invoice
with transactions on it. These transactions have a billing code. This
billing code is is another table but has another field which will be common
to more than 1 billing code i.e. a nominal ledger code. What I need to do
for a output is be able to group these transactions by the nominal code held
in the billing code file. I don't really want to add the nominal code into
my transaction table.

Example 1: "Invoice Print"
Invoice Total 100
Transactions
100 Value 40 (NL Code = 3000)
101 Value 10 (NL Code = 2000)
102 Value 20 (NL Code = 4000)
103 Value 30 (NL Code = 3000)

What I would like to do is the following:

Example 2: "File Output to Accounts"
HEADER: Invoice,100.00
DETAIL:2000,10.00
DETAIL:3000,70.00
DETAIL:4000,20.00

I hope this makes sense.

--
D Newman

Sigma Freight Systems Limited
http://www.sigmafreight.co.uk

digitalmetaphors

Use query linking. In the detail query, you'll need to ORDER BY the linking
key field and also any ORDER BY fields from the master query, then you can
ORDER BY the NLCode field.


Cheers,

Jim Bennett
Digital Metaphors