Hi,

Im needing to make an Access database to store seat positions and who sits in them. E.G.-

             Seat
Row   117    118   119   120
A       Bob   tom    Dik    tim
B         -       -       -     etc

I need to be able to show the table on a webpage and i need to also have another page where i can insert and change the names on each seat.

Now im not asking for someone to do all this for me LOL but, im even having trouble figuring out how to layout the initial table in the blank database (fields etc) in Access to accomplish the above and if someone can suggest how to do that or point me to a relevant tutorial - i'd b very grateful :)

thanks for reading

Red..

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.

Firstly - thanks for taking the time :) - here is the info.....

There are 22 rows from top to bottom (V to A) A being bottom.
and 14 seat numbers from left to right (columns - 117 to 130)

Its actually a section of a football stadium if that helps you visualise it better :) I need to be able to look at the webpage as if im standing on the pitch looking at who's seated where.

Anymore help is more than welcome - thanks a lot

Red..

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..

Just popped back on to publically thank Michael for helping me so much :)

Ive got exactly what i needed to get my idea up and running now and things are looking good.

thanks mate

Red..