linking tables

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Linking tables

Linking tables

resolvedResolved · Low Priority · Version 2007

Jordana has attended:
Access Intermediate course
Access Advanced course
Access Introduction course

Linking tables

If I link 2 pieces of information in 2 tables and one is deleted or removed, will there be some message that informs me of this?

RE: Linking tables

Hi Jordana

Thank you for your quesiton. The feature you are referring to is called Referential Integrity. It can be set when the relationship is created between the tables. Microsoft have an article describing the options:
http://office.microsoft.com/en-us/access/HA100963201033.aspx?pid=CH100645771033

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Tue 14 Apr 2009: Automatically marked as resolved.


 

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips


Server loaded in 0.09 secs.