G
Guest
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
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