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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.