create a junction table 1

[withoutwax]

Would be grateful if someone could tell me how to create a junction table. These are the tables I already have:

tblmember:
- MemberID
- First Name
- Surname

tblOrganisation:
- OrganisationID
- Organisation
- Address

tblCategory:
- Category

I need to set up a many-to-many relationship between these three tables.

Any assistance would be gratefully appreciated. Thank you in advance.

 

[PHV]

Have a look here:

http://r937.com/relational.html

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