I do know how to do this; however I am having difficulties with the student
data files downloaded from www.course.com for 2003 Access Introductory book.

In Tutorial 3, Question 4: It reads: Define a one-to-many relationship
between the primary Recruiter table and the related Student tabe. Resize the
field lists, as necessary, to display all the field names. Select the
referential intgrity option and the cascade updates option for the
relationship.

I clicked on the icon for Relationships and in the Recruiter table the
Primary key is SSN; in the corresponding Student table, SSN is a foreign key
- therefore I should be able to make the relationship.

However, I go through the steps that I was taught and that are stated in the
book and I get a message popped up that says "M.O.A. cannot create this
relationship and enforce referential integrity..." going on to explain that
it is in violation.

It shouldn't be though; I have done this steps at least 100 times before and
continuing and every other time it has worked smoothly; until now.

Any suggestions or imput? Any/all will be appreciated, thank you for your
anticipated feedback.

It sounds like you likely have unmatched child records in the Student table.
Try selecting the Queries tab. Click on the New button. Select the last
wizard which is the Find Unmatched Query Wizard. Go through the various steps
of the wizard to create a query that will help you locate the offending
records.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"RHiggs" wrote:

> I do know how to do this; however I am having difficulties with the student
> data files downloaded from www.course.com for 2003 Access Introductory book.
>
> In Tutorial 3, Question 4: It reads: Define a one-to-many relationship
> between the primary Recruiter table and the related Student tabe. Resize the
> field lists, as necessary, to display all the field names. Select the
> referential intgrity option and the cascade updates option for the
> relationship.
>
> I clicked on the icon for Relationships and in the Recruiter table the
> Primary key is SSN; in the corresponding Student table, SSN is a foreign key
> - therefore I should be able to make the relationship.
>
> However, I go through the steps that I was taught and that are stated in the
> book and I get a message popped up that says "M.O.A. cannot create this
> relationship and enforce referential integrity..." going on to explain that
> it is in violation.
>
> It shouldn't be though; I have done this steps at least 100 times before and
> continuing and every other time it has worked smoothly; until now.
>
> Any suggestions or imput? Any/all will be appreciated, thank you for your
> anticipated feedback.