Drop Down List and Field Values

[Charles Blackwell]

I have created a drop down list of fields from one table, courses, that creates fields in another table, tutoring, but for some reason its only listing one of the courses from the other table no matter what I change the course id number to in the tutoring table.

What I want it to do is change the course name in the course name field everytime I change the course id in the tutoring portal. The course name in the tutoring table is a calculation. course_name in tutoring = Courses::course_name.

I have included a screenshot of the layout.

[Alexis C]

It seems to me like your using the same occurence of your "course" table in both portals. You should probably have one occurence of the table that's linked to the "problem" table and one that's linked to the "tutoring" table (see attached picture) and use the "name" field from those occurences accordingly in your portals.

Hope it helps!