Solved Seat Reservation / Grafik Programme

Make sure to unblock and enable the document.



enable.jpg
 
You probably want to add the fields to the seating table. This will help to search and find data. "Seats remaining in a row", "Seats Remaining in a block", "Greatest group of seats next to each other". "Best Seats"
RowNumber
Block
Rating

Where rating can be a value from 1 to 10 on how good the seat is.

I know when I order seats for a concert I put in which block I want and how many people in the group. The computer will recommend the best seats that fit the group. You can code something similar if required.
 
see post #21, if you are having problem.
just cosmetic look, now has color coding for each "Block".
 

Attachments

see post #21, if you are having problem.
just cosmetic look, now has color coding for each "Block".
Good morning Arnelgp!

I cannot thank you enough for this sample DB! The concert is on the 5th Nov. and ticket sales are really coming in now so I am under a bit of time pressure. You have made my life sooo much easier.

I just have one question :)
I actually posted an older version of the plan as I was not expecting anyone to really make the plan for me! The seats with an alphabetic suffix have now been changed on the new plan - numbering the seats straight through. (184A is now 185, 184B 186 and so on right through to 717)
I am of course more than willing to maually change the plan but I was just wondering if you had an easier way?

I really appreciate your help!
Marion
 
i will let you know if i already made the changes.
i can do the changes in code, it will be painful for you
to do it manually.
 
i will let you know if i already made the changes.
i can do the changes in code, it will be painful for you
to do it manually.
Wow again thank you so much. If you ever in Germany please come round! I owe you one big time-We have really good wines in our region
 
The easiest solution would be to have two fields in the table. SeatID and SeatName. Then number the ID with a continuous number and use in code. Use the Name on forms and displays. This way you can rename without ever changing code.
 
Thank so much to everyone for the very helpful hints and answers. A very special thsnks to arnelgp!
I have a very nice little system up and running - Apart from a few minor updating of forms that I'm still working on
Couldn't have done it without you all!
Thanks again!
 

Users who are viewing this thread

Back
Top Bottom