Checklist Missing Items

Hello:

Sorry that this is a bit involved, but any help would be appreciated.

I have an application that requires a checklist for salesmen. The list of
checklist items is specific to a territory, so several salesmen will have the
same checklist items. As a salesman accomplishes an item, we check it off.
The tricky part comes in that we want to pull a list at any time of what the
salesmen have NOT accomplished from the list.

I started with table1 as a checklist master by territory. Then with table2
as a checklist table that holds the accomplished items by salesman:
Table1:
ChklistMasterID
TerritoryID
Item

Table2:
SalesmanID
ChklistMasterID

I can't figure out how to build a query that will show each salesman's
missing items.

Help!

Thanks
Steve

Steve,

What do you mean by "As a salesman accomplishes an item, we check it off".
Where is this check off recorded? You show nothing in the tables that records
this. So I can't see how you can determine what a salesman has or has not
done.

The tables that you show simply tell you what the salesman has to do.

Something is missing.
--
Chaim


"Steve Happ" wrote:

Hello:

Sorry that this is a bit involved, but any help would be appreciated.

I have an application that requires a checklist for salesmen. The list of
checklist items is specific to a territory, so several salesmen will have the
same checklist items. As a salesman accomplishes an item, we check it off.
The tricky part comes in that we want to pull a list at any time of what the
salesmen have NOT accomplished from the list.

I started with table1 as a checklist master by territory. Then with table2
as a checklist table that holds the accomplished items by salesman:
Table1:
ChklistMasterID
TerritoryID
Item

Table2:
SalesmanID
ChklistMasterID

I can't figure out how to build a query that will show each salesman's
missing items.

Help!

Thanks
Steve

Hello Chaim:

Sorry for the lack of info. Table 2 holds the items that the salesman
accomplishes. In other words, the "checking off" process means we write a
record into table 2 of what the salesman has done. So, Table 1 holds the
complete list for the territory and table2 holds what the salesman has done.
I need to know for each salesman which items from table 1 are NOT in table 2.

Is that clearer?

Thanks
Steve

"Chaim" wrote:

Steve,

What do you mean by "As a salesman accomplishes an item, we check it off".
Where is this check off recorded? You show nothing in the tables that records
this. So I can't see how you can determine what a salesman has or has not
done.

The tables that you show simply tell you what the salesman has to do.

Something is missing.
--
Chaim


"Steve Happ" wrote:

Hello:

Sorry that this is a bit involved, but any help would be appreciated.

I have an application that requires a checklist for salesmen. The list of
checklist items is specific to a territory, so several salesmen will have the
same checklist items. As a salesman accomplishes an item, we check it off.
The tricky part comes in that we want to pull a list at any time of what the
salesmen have NOT accomplished from the list.

I started with table1 as a checklist master by territory. Then with table2
as a checklist table that holds the accomplished items by salesman:
Table1:
ChklistMasterID
TerritoryID
Item

Table2:
SalesmanID
ChklistMasterID

I can't figure out how to build a query that will show each salesman's
missing items.

Help!

Thanks
Steve