Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
should I make my database just 1 table or a series of tables?
thanks for the replys. As for making POC and the other POC__ fields a separate table is not needed. They are not required and can be null; it does not need to be validated against because it is only used as contact info on the item listed. UserID won't be a PK. Only itemID. All items have...- mumzer
- Post #4
- Forum: -General database discussion
-
should I make my database just 1 table or a series of tables?
I am building an electronic bulletin board at work. A database is needed to store the information about the items submitted, using MS SQL Server. I feel that I should make the database just 1 table with an itemType field, because most of the data is the same for all item types-vehicles, real...- mumzer
- Thread
- Replies: 3
- Forum: -General database discussion
-
Getting 2 db entries per submission
I have written a survey in ASP using javascript and the answers are dumped into an MS Access 2000 database. Whenever I press the submit button on the form, 2 almost duplicate records are recorded to the database. The only reason they are not duplicates is because I have an autonumber field as...- mumzer
- Thread
- Replies: 0
- Forum: Microsoft: Access Queries and JET SQL
