troubleshooting Question

architecture question

Avatar of -Dman100-
-Dman100-Flag for United States of America asked on
ASP.NETMicrosoft SQL Server 2005
3 Comments1 Solution254 ViewsLast Modified:
I have a request to build a one page time reporting form that allows a user to select any Sunday of the year.  Once they have selected a Sunday, they should be shown a table with 7 columns representing the days of their selected week; each column should have an input to allow the user to enter the number of hours they worked that day.  Upon save the user records are stored in the database.

I already have a a user table, but I need to create a table for the time reporting.  I should have one table for the days of the week....i.e. Sunday thru Saturday with a foreign key relationship to the user, but I'm a little thrown by the any Sunday of the year selection?  How should that be handled?  How should I capture that in the database (another table)?  Also, how would I allow the user to only select a Sunday out of the year?  I can have a calendar popup, but I'm not quite sure how to only allow the Sundays of the year be selected.

Any suggestions or better ideas on the table construction would be helpful?

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros