About the database
My database holds information about ticket sales with 9 tables in it (employee, tickets, venue, customer, customers card info, genre, invoice and order)
I know that there will be some flaws in my design such as having the customer card info seperate from the main customer table but it works with the way it's running at the moment without any problems.
I'm trying to produce an invoice and display each customer's tickets that they have bought but the problem I get is that it shows all the tickets that has been sold I just cann't get it to break each customer up and display only the tickets that they have bought.
I've included a picture of the relationship so you can understand how I have structured the database.