How to work with 100 fields on a web form in ASP.NET6 Points
How to work with 100 fields on a web form in ASP.NET
a few seconds ago|LINK
i am having a requirement where i have to create a form having nearly 100 fields. i have divided the form into three modules using multiview/tabs.can i have 100 columns in sql server table or should i use three tables by setting relationship using primary and foreign keys.
What I have tried:
i have tried using multiview where i have divided the form into three views and and make first view submission table as primary and remaining two views with fields as foreign keys. also tried by executing multiple query(transactions) at a time,but could not find the best solution.which one is effiecient and best!!!.