Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
access course microsoft training - many many relationships

Forum home » Delegate support and help forum » Microsoft Access Training and help » access course microsoft training - Many to many relationships

access course microsoft training - Many to many relationships

ResolvedVersion Standard

Laura has attended:
Access Intermediate course

Many to many relationships

I am building a database where clients can have more than one assessment. Linking these 2 tables (Client/ Assess), does this need to be a many to many relationship and therefore need a linking table? or can it just be linked by client ID 1-many AssessID?

RE: many to many relationships

Hi Laura

I suggest using a linking table to manage the relationship between the client and assesment tables.

Regards

Richard

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.09 secs.