linking a table with a lookup field to a junction table 1

[withoutwax]

I have created a junction table to link three tables. However I also have a table with a lookup field and want to relate this to the juntion table too because the member and organisation will need the ability to select several categories. I have tried reading up on this but I need it explained to me in simple terms, I'm afraid.

Tables:

tblmember:
- memberID
- name
- address

tblorganisation:
- organisationID
- organisation
- address

tblcategory:
- categoryID
- category

tbljunction:
- memberID
- organisationID
- CategoryID

tblCats
- CatsID
- Cats (lookup field from "Category" tblcategory)

thanks

 

[PHV]

You don't need tblCats as in tblJunction you may have several CategoryID for the same memberID,organisationID pairs:
tblJunction:
- junctionID (PK)
- memberID (FK to tblMember)
- organisationID (FK to tblOrganisation)
- CategoryID (FK to tblCategory)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886