Invoice problem

[jinz]

I have a book database how can have a report for an invoice



E.g an invoice for just 1 customer which shows the book purchase price book name book purchase date (all from book table) and the customer name (from customer table)

I have the database but customer table and book table is different, that's the problem.

[jzwp11]

It sounds like you will need to create a query that includes both the book table and the customer table. Select the field you need to display in the invoice. Then create a report (i.e. the invoice) based on that query.