Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access course microsoft training - Many to many relationships

Resolved · Low Priority · Version Standard

Reply Tue 5 Jun 2007, 12:09Delegate Laura said...

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?

For upcoming training course dates see: Pricing & availability

Reply Fri 8 Jun 2007, 09:42Trainer Richard said...

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 articles

· How To Use A Parameter Query In Access
· How To Resolve Access Data That Gives You Déjà Vu
· Some Simple Database Questions Answered
· How To Use Calculation Fields In Microsoft Access
· What Is The Database Documenter And How Is It Used?

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips