Ok, one more little snag.
I created a new layout based on a new table Demographics_VESTIBULAR. Relationship chart is below.
I set it up EXACTLY like I had set up my Demographics_OBJECTIVE relationship, which works just fine. What it does is when the EpisodeID changes, it makes a new record in that table and allows data entry.
I set up a button that runs a script calling for it to Go To Related Records from table Demographics_VESTIBULAR and showing the record using the Vestibular layout I created. I Show only related records and match current record only. the script then Commits Records/Requests and ends.
When I click the button, nothing happens. I checked to make sure I have Add Records and Delete Records check in the relationship. Given that this is exactly like my Demographics_OBJECTIVE I don't get why this is happening.
When I use Go To Layout, it switches to the layout fine and allows data entry, but, of course, it isn't changing with any EpisodeID or PatientID changes. It just remains on whatever record was open there before.
So why is Go to Related Record not working, but Go to Layout does?