Making A Seating Chart

[sgricus]

Ok same database. I am making a database for a Theater Company.

I want there to be a seating chart, where you select a performance, you
can "select seats" with a command button, which opens a seating chart
looking object. Each seat will have a Seat ID which contains its
section, row, and seat number.

Here is where my problem is. I am trying to set up the relationship
with tblPerformances. There are 120 seats in this theater, there can't
be any more. But sometimes there can be less.

What I want to do is show the same seats, but the administrator of the
database company will have to enter which seats happen at which
performance. So, for instance, Seat 1 (section left, row A, seat 1)
will be there at every performance that has 120 seats, but will not
when the performance has 100 seats.

So here are my questions:

1) How do I set up the relationship so that 120 seats can be chosen,
but the same ones over and over again, for different performances? (so
for performanceID 6 and performanceID 7).

2) What I want to be able to do is to be able to select the seats on
the seating chart, and have those values do 2 things....automatically
be linked BACK to the frmPurchase, where the fields originate, AND
setValue at being "sold" (which is probably going to be a checkbox).
This should all happen when you close the seating chart.

Any help in as easy language as possible would be great!

Thanks!