Solved Seat Reservation / Grafik Programme (1 Viewer)

[MajP]

Make sure to unblock and enable the document.

 

[MajP]

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.

 

[arnelgp]

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

 

[MarionD]

i removed most of the "flicker" when adding/updating "seat" record.

Hi there! Sorry found it! I hadn't unblocked the db!

 

[MarionD]

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

 

[arnelgp]

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.

 

[MarionD]

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

 

[MarionD]

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.

 

[MajP]

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.

 

[arnelgp]

here test it again.

 

[MarionD]

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!