Relational data problem

[excel]

Hi,

I am working on a student database. The students are in the database and I'm trying to set up a Call Center. The Call Center will be for when teachers call a student they will log details of the discussion and be kept as part of the student record.

At this time, I cannot get the appopriate student to show up after click the Call Center button on their record. For example, I am on J. Smith's student record. I click the Call Center button on J. Smiths record and it goes to the Call Center Layout. However, J.B. Good is the name in the student record. Here is my relationship.

Table - Call Center - (Student Name) is the field. This field relates to the Full Name field in another table.

[aldipalo]

IMHO, using a name field in a join leaves you open to iffy results. Do you have a Student_ID field that is unique to each record? If not add the field to both tables and populate the Student_ID field in the student table. If so, relate the two tables by the ID field and you should see better results.

BTW, you are using the Go To Related Record command, aren't you? Make sure you are set to "Match only related Records" and "Match current record Only."