Invoice Printing

[fidelis]

Hello,

I am quite new to MS Access so trying some tutorials to design a db to store invoicing data. My db relationship is as shown in image.






Now i want to create a printable report to print each invoice separately with Cust and Supplier name instead of their codes. Pls help to do it.

Thanks.

[pbaldy]

Create a query that joins the 3 tables together, which will enable you to return the names as fields. Then base your report on that query.