Newbie needs help/suggestion

redk, what you try to do very well depends on the amound of rows and Seats per row you are going to have. If there are just 5 rows it would no be a broblem vreating a column for each row but if there are 120 or more you might want to consider creating a table for the person that occupies a potential seat and the have an entry like 117A or 005C for each individual. This value would have to be unique in the databse. Then you need to figure out not to accidently "sell" a seat twice so there would have to be either a database for all seats so you can populate it to a dropdown or so. Well, post what the extend fo the database is, how many seats would there be and stuff and you should get a more specific answer.

Well if you want to keep it simple I would probably have a table like:
Row   Seat   Occupied
A       117    Brian
A       118    Free
...      ...     ...
V       128    Jim
V       129    Jeff

And then just run update statements to change from Free to a name or from a name to free. This is a very simple layout and would not let you collect more information. For that to do you could have a second table with visitor details and add under Occupied you would just have the Visitor ID. It all depends on how many people might be sitting in this section into the future. If your server has ASP.Net it would be extremly easy to do that using a Datagrid, actually I have a script that could be adapted to that in less than an hour. If you use asp it's much more code as to changing each field in a table view so you can visualize the stadium. Let me know, maybe I can post you a little sample....

Thats pretty cool :)

Thanks so much for your efforts - Im gonna PM you now!

Cheers

Red..