Daily Check List = Challenging

[JB]

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

 

[Duane Hookom]

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