Message for Mike Painter or someone else who can help me?

S

skulmat

Some time ago Mike Painter answered a question i had, and i am wondering if
he could please explain to me clearer what to do as i am a newbie at this(his
ansewr is at the bottom of this post). Thankx


I am using a modified northwind databse.
I just have one problem, i want to modify it that i can set it up
that i can choose it to be either a "proforma" invoice or a final
invoice. (i want to be able
to have multiple proforma invoices). And then i want to be able to
lets say ask for the copmuter to show me all the final invoices from
past, or just all the diffrent proformas this particular order went
thru. what would be the best way to go about this.
And they will all share the same order number so i can track the
diffrent steps the invoice went in. so i can tell the computer to
print up all diffrent versions of the invoice.
Click to expand...

Ouch.
Invoices are just reports, so the first question is what differentiates the
underlying data to make it proforma or final?
Will a proforma invoice look a lot different or will it just have some text
that tells what it is?

I suspect the order number table will end up with a two part key.
OrderNumber*InvoiceNumber and the invoice header will have a Boolean field
for proforma or final.
Each "Invoice " would have to be separate for what you want.

It should be interesting.
 
Top