InterGeorge
Technical User
Dear All,
Don't chop of my head - I'm a newbe in Access!
I need to create better prints from our LINUX accounting system. The database is in Firebird/Interbase 6.0 SQL.
The developer know there is a *BIG* issue with printing, like a make a price list takes 4 hours to extract data's and customer statements could be ether printed detiled (800 pages) or 10pages single line. All what they due is keep promissing and never deliver any results. At least now for 10 months. If I'm looking up the F&Q there are people waiting even longer.
I made a ODBC link to the Linux SQL-system to W2k MSAccess, works fine, all tables (97) are here. Now I have to do some "backward engineering". With the items I have had no problems, I print now any kind of reports in 10 minutes.
But the accounting:
To create customer statements I need to link the invoice file with the client. But there is no field for the clinet in the invoice file?
After a bit investigating i figure out that the key is the general transaction ledger(GTL). There I have the INVOICE_ID and CLIENT_ID to link the two together.
But the GTL-INVOICE_ID is is a text field and the therefore I can't link them with INVOICE_ID (num)! At least as easy I'm thought!
I did check, in the GTL file is another field, TRANSACTION_ID . If this is set to 7 then it's a invoice and the INVOICE_ID is then always numeric. If the TRANSACTION_ID is not 7 then it could be ascii in the INVOICE_ID.
There is one (numeric) field always empty, TR_LINK_ID
I assume the developer copy the INCOICE_ID to TR_LINK_ID to create the link at runtime!
I opended the SQL-database ReadOnly to make sure nobody incidentally delete/change datas to keep the accounting safe.
I thought ether copy the file via query in aonther (local)table (how?) and create the link's there (*static*) or there is maybe a solution during the query to temporary set the number in TR_LINK_ID, make the link to client, read the next record and set there temporary TR_LINK_ID (loop) (*dynamic*)
You know the feeling when you believe to have the answer and missing just one thiny little piece? That's where I'am.
I did googling for two days and did find anything similar.
So, any thoughts from a brainer?
(answers please in: "ACCESS FOR DUMMIES"
Thanks a lot in advance.
George
Don't chop of my head - I'm a newbe in Access!
I need to create better prints from our LINUX accounting system. The database is in Firebird/Interbase 6.0 SQL.
The developer know there is a *BIG* issue with printing, like a make a price list takes 4 hours to extract data's and customer statements could be ether printed detiled (800 pages) or 10pages single line. All what they due is keep promissing and never deliver any results. At least now for 10 months. If I'm looking up the F&Q there are people waiting even longer.
I made a ODBC link to the Linux SQL-system to W2k MSAccess, works fine, all tables (97) are here. Now I have to do some "backward engineering". With the items I have had no problems, I print now any kind of reports in 10 minutes.
But the accounting:
To create customer statements I need to link the invoice file with the client. But there is no field for the clinet in the invoice file?
After a bit investigating i figure out that the key is the general transaction ledger(GTL). There I have the INVOICE_ID and CLIENT_ID to link the two together.
But the GTL-INVOICE_ID is is a text field and the therefore I can't link them with INVOICE_ID (num)! At least as easy I'm thought!
I did check, in the GTL file is another field, TRANSACTION_ID . If this is set to 7 then it's a invoice and the INVOICE_ID is then always numeric. If the TRANSACTION_ID is not 7 then it could be ascii in the INVOICE_ID.
There is one (numeric) field always empty, TR_LINK_ID
I assume the developer copy the INCOICE_ID to TR_LINK_ID to create the link at runtime!
I opended the SQL-database ReadOnly to make sure nobody incidentally delete/change datas to keep the accounting safe.
I thought ether copy the file via query in aonther (local)table (how?) and create the link's there (*static*) or there is maybe a solution during the query to temporary set the number in TR_LINK_ID, make the link to client, read the next record and set there temporary TR_LINK_ID (loop) (*dynamic*)
You know the feeling when you believe to have the answer and missing just one thiny little piece? That's where I'am.
I did googling for two days and did find anything similar.
So, any thoughts from a brainer?
(answers please in: "ACCESS FOR DUMMIES"
Thanks a lot in advance.
George
