Drow-down List

[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.

[AHunter3]

Can you re-explain?

 

I don't know what you did, but I know what you did not do: you did not create a dropdown list of anything, anywhere, that creates FIELDS, anywhere, at all, ever. Perhaps it created VALUES WITHIN a field, the field to which the value list is attached; or perhaps it created RECORDS, most likely via a PORTAL which the field is sitting in and to which the value list is attached.... ?

 

You also most likely did not create a dropdown list of FIELDS. Of the values OF a single field, most likely.

 

I think probably you mean that you have one field, formatted with a dropdown list of values from another field, and that in some fashion which you have not sufficiently explained or specified, you either are successfully creating RECORDS in a table by selecting a value from the dropdown value list, but with some kind of result that you do not like; or else, no, you are unsuccessful at doing that and are instead only changing the value in one record, which you created the first time you selected a value, to a different value, overwriting the original record's value... ?

 

I do not know what "it" refers to in this phrase: "...but for some reason its only listing one of the courses from the other table"

 

I do not know if you mean that the VALUE LIST is only listing one of the many values you created in the "one table", or if the value list is fine but the records you have successfully created is (consists of) only one value, i.e., you've only succeeded in creating one single (related) record (probably in a portal, probably in the portal of the one parent record, possibly in the portal of multiple parent records which unfortunately have the same local value in the relational key field that connects that table to the other).... ?

 

I'm sorry if this sounds like I'm annoyed or impatient; I'm actually not, but I need you to realize how and why it is difficult to provide help when one does not not know what the problem consists of.

 

(i.e., your help request has been sitting out there for 4 hours not because no one likes you but because, in all likelihood, no one else has more of a clue than I did what you meant. The folks on this board are very helpful when they can be. Please don't leave or get frustrated, but do rethink and reword your answer. Actually in the process of doing that you may end up answering your own question)

[blackwell]

Sorry about that.

 

Here's the problem:

I have 3 tables: students, courses, and tutoring

 

students:

---------

id (unique)

name_first

name_last

 

courses:

--------

id

course_id

course_name

grade_mid

grade_final

 

tutoring:

--------

id

course_id

course_name (=Courses::course_name)

grade_mid

grade_final

 

The key of all the tables is: id. They are all connected in the relationship graph.

 

A form that user fills out contains the student information and the course information. The tutoring info comes from the course info. You can only select a course in tutoring, if the student is currently taking that course.

 

I have created a drop-down list that is filled with the all the courses ids of the courses that student is taking. So, that only ids that are in the tutoring section are the classes that student is currently taking. I also created a caculation in order to automatically populate the course name (see above).

 

What I want to do is, when I switch the course id via the drop-down, I want the course name to change. Right now, its not doing that. Its only listing the name of the first course that was entered for the student.

 

Thanks for you help.

 

Charles

[blackwell]

Both the course and the tutoring info are in a portal. Also, you can create records in the tutoring table via the id relationship between the course and tutoring tables.

[AHunter3]

What I want to do is, when I switch the course id via the drop-down, I want the course name to change.

 

This field that you call the "course name" -- what table occurrence is it from? Is it courses::course_name? If not, why not?

 

And what is the native table occurrence of the layout where you've got this field? Is it a Tutoring layout? A Courses layout? etc?

[blackwell]

The layout is pulling info from the students table.

[AHunter3]

OK. You are ON a layout of the Students table. The ID field you are changing, when you look at it in layout mode, does it have colons in front of the field name, like this?

 

::ID

 

??

[blackwell]

Yes. It has colons. The course table is related to students through the id. The course table is related to the tutoring table through the id and the course_id. Once the user enters the course information in the courses portal in the student layout, I use that to enter info if a student received tutoring in that subject. I am changing the course_id in the tutoring portal to lookup the rest of the information from the courses table. Is that clear?