creating and Keeping track of diffrent versions of an invoice.

S

skulmat

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 a "proforma" invoice and 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.

thankx
 
T

Tom Wickerath

Perhaps you can use something similar to Allen Browne's Creating an Audit Log example:
http://members.iinet.net.au/~allenbrowne/AppAudit.html


Tom
_____________________________


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 a "proforma" invoice and 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.

thankx
 
Top