Status Database Help

  • Thread starter Thread starter Manuel Banuelos
  • Start date Start date
M

Manuel Banuelos

Hello everybody,

I am trying to create a Status Database, you know for weekly statuses of projects, I am trying to create a form that would show current and
previous weeks info (status), I have a couple of pulldown menus to show the person and another one for the project (for current week). My question is: Does anybody know how to link the current week with the previous week based in the info given this week, name and project, from the pulldown?
I have been fighting this one and asking several Access Gurus but no deliverable yet. Your help would be greatly appreciated.

Manuel Banuelos
 
I believe your table design isn't the best one to use. Each project should
have a unique ID -- that is your link to all records pertaining to that
project.
tblProjects
ProjectID (primary key)
ProjectName

You should have a table of statuses:
tblStatuses
StatusID (primary key)
StatusName


You then should have a table that is similar to this:
tblProjStatus
ProjectID
WeekDate
StatusID
--

Ken Snell
<MS ACCESS MVP>



Hello everybody,

I am trying to create a Status Database, you know for weekly statuses of
projects, I am trying to create a form that would show current and
previous weeks info (status), I have a couple of pulldown menus to show the
person and another one for the project (for current week). My question is:
Does anybody know how to link the current week with the previous week based
in the info given this week, name and project, from the pulldown?
I have been fighting this one and asking several Access Gurus but no
deliverable yet. Your help would be greatly appreciated.

Manuel Banuelos
 
Back
Top