Solved Seat Reservation / Grafik Programme

[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!