Back to the Data Model.
Subject: Ticket Purchases in Groups
Question: Hi Barry, First of all, thanks for this wonderful resource! It has helped me
tremendously over the past number of years.
I've got a question that I thought you would certainly know the answer to.
I'm working on putting together an ERD for the following logic:
1. A customer needs to purchase a ticket to an event.
2. They need to provide their name, email, and phone number.
3. They may purchase 1 or more tickets for the event.
4. If they purchase more than one ticket, they must also submit the name, email,
and phone of other people for each additional ticket.
5. I would like to be able to group the ticket sales by both order (if they
ordered for multiple people) as well as list out the individual tickets with
the individual contact information as well as the purchaser of the ticket.
Here is a link to illustrate what I've got so far - http://d.pr/fumW Thank you very much for your time!
© DataBase Answers Ltd. 2012