I am creating an invoice. I have several serial numbers that will be listed
on the invoices. I will I have two scenario on how I will get the data.
Either I will pull the information from an accounting program. In that I
will actually entered the invoice in the accounting system. Then I will
import the data into an Access Database, which will have the invoice number,
inventory Id, serial number and amount date etc. The problem with using the
invoice in the accounting program is that it does track the information but
it list the serial number for each item id in one column. I could have
50-100 serial numbers. Which means before it list the second item purchased
it could be pages before I get to that item. It is possible that I only have
4 or 5 serial number for the same inventory ID. So I want to control the
layout in Access so that I can have it list 8 on a row and 5 in a column or
the other way around. Not locked into 8 across and 5 down. The other way is
I process the invoice in the Access database and I have a program that will
write the information back. Either way I need to be able to control how the
invoice layout. Writing back is not a problem because the program imports
..csv file format.

Access is a tool box which can do all of this kind of stuff, like building a
multi-story building. The "foundation" is a good understandinng of and data
rules for the process/ information that is being databased, and the first
floor is a good table structure. You really haven't haven't told us any of
that and so I don't think that anybody is going to be able to answer you
question in they way that you intend.

You'll need to know and understand your data and it's structure. If you're
going to use the accounting program, then, as a minimum, you need to
understand and describe the data and data struction that is coming out of it
in the .csv files.

Hopefully that helps at least a little!

Sincerely,

Fred

Let’s see. First of all I have a program that will read the data from the
accounting program using Pervasive 9. However, I am designing the invoice in
Access. I have a program that will pull all the information from the
accounting program into Access Tables. It also, includes forms, reports,
etc.. There are several tables. I will have to establish link between the
Journal Row table which contains the detail data for the invoice and a box
checked off if it has a serial number. The Journal Serial Number contains
the Serial Number. I have to still see how it links the invoice to the line
item with the Serial Number. Once I have that figured out and on the Form I
have the correct invoice with the Serial number listed. Then I would like to
tell it to print the Serial number in a certain format. Such as 8 across and
5 down. Does this help any?
"Fred" wrote:

> Access is a tool box which can do all of this kind of stuff, like building a
> multi-story building. The "foundation" is a good understandinng of and data
> rules for the process/ information that is being databased, and the first
> floor is a good table structure. You really haven't haven't told us any of
> that and so I don't think that anybody is going to be able to answer you
> question in they way that you intend.
>
> You'll need to know and understand your data and it's structure. If you're
> going to use the accounting program, then, as a minimum, you need to
> understand and describe the data and data struction that is coming out of it
> in the .csv files.
>
> Hopefully that helps at least a little!
>
> Sincerely,
>
> Fred
>
>