Scripting button to go to related student field

[TaiChi56]

I have one layout that has student information. The unique field is StudentID. I have another layout that has different information with the StudentID being the unique key. In the database relationship the studentid keys from both layouts is matched.

Now I made a button so when I am on a certain kid and want to find out some information from another layout I click that button to go to the that layout. But I cannot seem to script where the layout will open to that student's record by ID number. I can get the layout to open but it will just give me that last student that the layout was open in.

How do I script to go to that related ID? If I use related record it does not work.

[mr_vodka]

Go to Related Records script step with showing matching records only.

[TaiChi56]

^{Ok, I did as you suggested so obviously I have other problems because I cannot get it to work. I am attaching the file. When you click on attendance letter button it will go to the attendance letter layout. But it will not go to the related record that I show on there, the student ID it needs to go to in the example is 111111. But it defaults to what is in there already from last view. So now I am wondering if there is a relationship problem.}

StudentSchedule_FmExample.zip

[mr_vodka]

Your structure seems off. What are you trying to do here? Currently you do not have any records in the enrollment table that matches your student table based on the Student_fk_import. That will stop the relationship passing through to the letter table.

Furthermore, if this is multiple letters for each student, then the relationship should be from the student to the letter table. Or if its a letter for each enrollment records then you may be able to just send the letter based on that table.

[TaiChi56]

Yes a student can have more than one letter. Not sure how to fix the structure though.

[bruceR]

There are no related records.

You are pointing from Students to Enrollment to Letters. That would work if there were Enrollment records. But in your file, there NO enrollment records.

Probably Letters should relate directly to Students?

Second problem. Your script goes to the Letters layout; THEN tries to go to related records. Drop the first step (go to layout)

[TaiChi56]

Thank you. I will work on that.