access course microsoft training - Many to many relationships

The UK's most regular instructor-led training courses.
Training information: access course microsoft training · Access training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Many to many relationships

Laura has attended:
Access Intermediate course

by - delegate Laura [1 post] (2007 Jun 5 Tue, 12:09) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: many to many relationships

by - trainer Richard platinum contributer [818 posts] (2007 Jun 8 Fri, 09:42) Reply

Hi Laura

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

Regards

Richard

· Microsoft Access Mistakes to Avoid
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Discover the Secrets within Your Business through Microsoft Access Training
· Microsoft Access Tighten your Security Controls
· Convert a Paper Trail to a DBMS

Access tip:

Label printing

You can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps

View all Access hints and tips