Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 multiple similar forms

Author  Topic 

auser
Starting Member

2 Posts

Posted - 2011-01-13 : 04:37:39
Hi,

I have a website with 6 or 7 different contact forms. most of them share the same fields, name, surname, age... and they differ in a couple of fields.

What would be the best approach to design the database? create a table for each form? or 1 table for all the forms having all the fields?

Thanks

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-01-13 : 04:48:53
Creating the table(s) i.e design the database isn't a question about used forms.
It is a question about the datastructure...and we don't know anything about it.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2011-01-14 : 00:57:23
YOU can use a single table for storing data of diffrent forms..but you need to have a column in the table which diffrentiates the forms..
Go to Top of Page

waleedraza
Starting Member

1 Post

Posted - 2011-01-17 : 22:18:54
Yes Its So Easy Just Use 1 Table For All Forms.

http://www.meratvforum.com
http://www.meratvforum.net
Go to Top of Page
   

- Advertisement -