Relationships

[Guest]

Hi,

I have a table "current students" which lists all my current students
(Student Id, Name etc) and then I have another table "Staff" which lists the
names of staff (Staff Id, Staff name etc)

Now each member of staff is responsible for one or many students.
So to link these together I have created a third table with just two colums.
One (Student ID) and two (Staff ID)

In table 3 I enter the student id of my student and then the staff Id of the
staff who they belong to.
My relationships are like this: Staff Id in table 3 is linked to Staff ID in
Staff Table
and Student ID in Table 3 is linked to Student ID in current students.

Now, when I do a form I can arrange it so that I have the members of staff
and then all the students who that member of staff tutors but I am having
problems creating a form that just shows the student and who there tutor is.
Can you help?

I keep getting a message saying mis match of data or something

Thanks,

 

[Guest]

Use form/subform. The form is for staff and subform (datasheet view) list
students.
In your form for students use a combobox for the staff field so as to pick
the staff.

 

[Guest]

I just tried that but that means I have to type the information in twice and
thats not what I want.

I just want to be able to add the information in my first form eg STAFF at
the top and then subform to show all the students and I can just just add and
delete students as I want. Thats no problem, I have done that..

Its the second form I am having problems with. I just want this one to
display the info eg a record for each student and who there tutor is... Hope
that makes sense

 

[Guest]

Just join the tables in a query you use the display students.
Student - Staff_Student - Staff

 

[Guest]

Its still telling me "type mismatch in expression" so wont work??

 

[John W. Vinson]

Its still telling me "type mismatch in expression" so wont work??

"1foxi" wrote:

The error means just what it says: you're trying to join two fields that are
of different data types, for instance joining a Number field to a Text field.

Could you post the actual fieldnames and data types of the fields, and the SQL
view of your query? Note that if you're using any Lookup fields, what you see
is *not* what you get - it may appear that the Staff field contains a staff
member name, but if it's a Lookup field then what it actually contains is a
Long Integer number field, concealed from your view by the Lookup misfeature.

John W. Vinson [MVP]