ASP Forum SQL I need advice about tables sandwichs | Posted 8:37am 13. October 2002 Server Time | hey guys... I'm starting a new web site from scratch. The info I'll need to gather will be: Username, Password, email, Comments1, comments2 and blahblah3, etc... so,... scenario number 1: all these info go into one table. scenarion number 2 : username and  password go in one table and a new table is created for each user to put email, Comments1, comments2 and blahblah3, etc... What is the best way to go? I hope I made this understandable :) Linda Kodo | Posted 9:48am 13. October 2002 Server Time | making a NEW TABLE for each person would not be in your best interest. make ONE user table with the required fields and INSERT each users info intot that table.   Follow scenario 1. Make an ID field(autonumber in access or identity in SQL server) to create a unique id for each user. sandwichs | Posted 10:31am 13. October 2002 Server Time | thanks.... I going to go that way then Reply to Post SQL I need advice about tables Back to Forum Page