Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by portjobs
-
finding unmatched records in three tables, with multiple criteria
Wow. I've never seen a query like that before. I had just finished a (much less elegant) solution: One query displaying all the current records in TableResCats (along with a new "fake" pk field combining R.ResourceID and C.CategoryID); another query listing all possible records for...- portjobs
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
finding unmatched records in three tables, with multiple criteria
Thanks much for the quick reply. I can see how that would work in principle. Unfortunately, Access won't allow me to define ResourceID_fk and CategoryID_fk as a multi-field primary key, because it will "create duplicate values in the index, primary key, or relationship." I've dropped ResCatID...- portjobs
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
finding unmatched records in three tables, with multiple criteria
I am working with three tables: 1) TableResources, with fields: ResourceID_pk, ResourceName 2) TableCategories, with fields: CategoryID_pk, CategoryName 3) TableResCats, with fields: ResCatID_pk, ResourceID_fk, CategoryID_fk, ResCatNote TableResources is already populated with a list of...- portjobs
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
