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

  1. 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...
  2. portjobs

    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...
  3. portjobs

    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...

Part and Inventory Search

Back
Top