Seating Chart

[Guest]

How would you make a seating chart for an auditorium in Access. I tried to
make something with check boxes that looks like the auditorium, but it was
taking a long time since I had to make a new field in the table for each
seat. Have any ideas on how to make one? Thanks

 

[Douglas J Steele]

You certainly don't want a new field in the table for each seat!

Instead, each seat should be a separate row in a table, with the appropriate
row number and seat number as its primary key.