Daily Check List = Challenging

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

So I have a dillema, and wondering if anyone out there has experienced
anything similar and can point me in a good direction.
I already have the main table setup that contains all the client's primary
data.
I now need to setup another table(s) that will allow for a checklist on a
form.
Here's what I'm trying to accomplish:
Each client can have at least 4 goals. Each goal must be checked off for
Monday - Friday each week. Somehow I'll also have to get the dates for those
days in there as well. :(

Not sure if that makes the best sense, but I'm just perplexed at the
situation.
Let me know if there are questions, I'll be glad to describe more.

-Jeff
 
This sounds like a basic cartesian query. Assuming
tblClients
========
ClientID (primary key)

tblDates
==========
theDate (primary key; values for each date)

tblGoals
============
GoalID (primary key0
GoalText

tblClientGoals
===========
ClientGoalID (primary key)
ClientID link to tblClients.ClientID
GoalID link to tblGoals.GoalID

You can then create a query like
SELECT ClientGoalID, theDate
FROM tblDates, tblClientGoals
WHERE ClientID = ??? AND theDate Between ##### And #####;

Use this query to append to a table with a structure like
tblCheckList
===============
ClientGoalID
theDate
Status
 
Back
Top