AnsweredAssumed Answered

Design Question

Question asked by tbcomputerguy on Apr 16, 2015
Latest reply on Apr 17, 2015 by philmodjunk

Title

Design Question

Post

Hi there gang.  I have a design question.  We currently use excel to track what we call our gov't tracking database.  Accounting isthe game.  the spreadsheet uses a grid to show all the companies that we do books for and which month each of the required services are due.  Services: basically 3; hst, recgen, wsib.  Companies: approx 100.  Months: pretty obvious.  I can't seem to figure out from which context I should design this.  From the company context, they could see all 12 months  and the required service due and if done.  Or from the Months context showing all the companies and required services due. This is a sample of what we have.  Just some thoughts would be helpful.  Not sure why I am stumped on this...I thought it would be straight forward.

DAve

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
               

 

               
               

 

               
               

JAN

               
               

JAN

               
               

FEB

               
               

FEB

               
               

COMPANY

               
               

Service

               
               

DUEDATE

               
               

DONE

               
               

DUEDATE

               
               

DONE

               
               

1013957

               
               

HST

               
               

31-Jan

               
               

YES

               
               

N/A

               
               

N/A

               
               

1013957

               
               

RECGEN

               
               

15-Jan

               
               

YES

               
               

15-Feb

               
               

YES

               
               

1013957

               
               

WSIB

               
               

31-Jan

               
               

NO

               
               

N/A

               
               

N/A

               
               

COMPANY2

               
               

HST

               
               

31-Jan

               
               

YES

               
               

N/A

               
               

N/A

               
               

COMPANY2

               
               

RECGEN

               
               

15-Jan

               
               

YES

               
               

15-Feb

               
               

NO

               
               

COMPANY2

               
               

WSIB

               
               

31-Jan

               
               

YES

               
               

N/A

               
               

N/A

               

Outcomes