Status Database Help

[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

 

[Ken Snell [MVP]]

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