I am not too sure how to go about this.
[u]First:</u>
I have 2 tables: "Shows" (Id, Name, Date of event, time, place, type of event...) and "Tickets" (ticketId, showId, ticketNumber, level, section, row, seatNumber, Price...) so, for each show, I have an inventory of tickets (relation of 1 to many).
[u]Now, what I have to do is:</u>
build a form that will help us add the same ticket information to a number of shows. For example, I want to add a ticket (ex: level = Floor, section = Center, row = 1, seatNumber = 1, price = $25.00) to shows selected in the form (ex: Show1, Show3, Show4, Show9)
[u]Front</u>
In the top part of the form would be the ticket information;
the bottom part would list all the shows (date of event > now) and with a control button or maybe a check mark to add the ticket.
When we select the show, the price information will show up beside the show's name in order to change it if we need too...
[u]I started the design of the form:</u>
in the top part I have all the fields with the ticket information but named parmLevel, parmSection, ... The fields are not linked to the Ticket table.
Below, I have the list of the shows I need (ShowNumber, Name, Date and Time) with an "Add" control button.
[u]I can't seem to :</u>
- find the right way to add the ticket to the shows selected
- show the price beside the show.
To add the ticket, I use an Insert Into SQL.
You are now my only hope to solve this problem...
Thanks in advance
Chantal