I have 1 file with 2 tables (students, faculty). From the students file, I would like to "assign" up to 3 faculty to a student via a Portal. In the faculty file, there is 1 record for each teacher. On the student file I have a value list "Faculty" that is calculated with each teacher's first and last name. How do I relate the 2 files? I tried passing the the StudentID field to a Faculty_LinkID in the faculty file. I have the relationship set to Create New Records. I think I am missing a simple step.

I appreciate any help or thoughts.

Thanks,

Jon

Jon,

Here's a simple example that accomplishes your goal. Notice the third table that contains a student and faculty id. This allows you to make the many to many link.

I made it so you can assign teachers to students or students to teachers.

Look it over. Ask questions

Don

student_faculty.fp7.zip

Edited September 20, 200817 yr by Guest

Thanks, Don. Your solution made perfect sense and helped me to find the solution. I appreciate your quick response.

Thanks again,

Jon