I am writing a program that keeps track of albums (music).
My database looks like this:
Database (simple)
Its in dutch but it comes down to this:
Klant table holds information about customers (name and such)
Album table holds information about album.
Order table holds information about which customer/date/payed and the orderid
Order_Items holds which albums and how much albums a customer bought.
also its not all of the tables just the ones im going to need for this.
I want to make a form like this:
Sale Form
the white field is a listview set to detail. I want to be able to choose a customer. Then i want to be able to add albums, after that i should click generate invoice and it needs to generate an invoice for the customer. (Crystal reports?)
Could you guys point me in the right direction?