Invoice Print Preview

[ermamplata]

Hi,
Please help me to find a best way to preview/print an invoice.

I allready have a forms design for sales transaction but when i trying to design a report for the sales invoice it will display all the data in the fields from the sales transaction, now i want to display only the current sales transaction on my forms.

I do not know which criteria that i have to use to filter, i cannot use the CustomerID and TransactionDate because CustomerID is not automatically input in the field when everytime i add a products/items only on the first record so from the second to the last field on that transaction was blank.

So i need to find a way how to make one criteria something like that or control number for each invoice to filter my report.

Ps...I'm Just a beginer in macro

Thx,
Matt

[orangeCat]

You may have a table design problem. You should be able to identify any transaction especially if you want to print/manipulate a specific transaction.
What is the table structure of your Transaction Table?

[NeoPa]

Matt, I'm sorry to say your thinking is not in tune with how databases work. I suspect you may benefit greatly however, from following the advice I expect orangeCat will be giving you if you co-operate whith them. Just as some light reading while you're waiting though, have a look at Database Normalisation and Table structures. You may find this a bit much to get into just now, but if you can manage to understand it, it will give you a big leap forward in your understanding of database concepts (and save you from untold numbers of headaches). You won't be sorry you persevered.

[ermamplata]

Hi Buddy, thx for your reply, here is Sales Transaction Table
Incase my structure is really bad i'm willing to make a new one from your guide.

Tabe Name: Sales Transaction

Fields: TransactionID (PK)
CustomerID (Linked to Customer Table)
ProductID (Linked to Product Table)
UnitPrice
Quantity
SalesDate

[ermamplata]

Matt, I'm sorry to say your thinking is not in tune with how databases work. I suspect you may benefit greatly however, from following the advice I expect orangeCat will be giving you if you co-operate whith them. Just as some light reading while you're waiting though, have a look at Database Normalisation and Table structures. You may find this a bit much to get into just now, but if you can manage to understand it, it will give you a big leap forward in your understanding of database concepts (and save you from untold numbers of headaches). You won't be sorry you persevered.

Oh that's ok Neopa, i'm happy you reply i'm willing to learn more and i know you can help me from you guide..

thx