From your description, Go To Related Records is not doing anything because, for the current record in Demographics, there are no related records in VESTIBULAR.
I don't see anything in your description here that would automatically create a new related record in VESTIBULAR. "Allow creation of records..." makes it possible to use the relationship to create a new related record, but it doesn't make it happen automatically.
Oh! I wonder why it works with Demographics_OBJECTIVE when I create a new patient record in Demographics?
So how can I create that record without creating a new record every time I click the button? (I want it to go to the record if it exists, or create one if it doesn't.) Is there something like If Exist, or the like?
I would guess that you have a related record in that case.
Since "Allow creation...." has been enabled,
Set Field [ demographics_VESTIBULAR::__kfPatientID ; demographics::__kp_PatientID ]
Go to Related Records [ ...
would work. The set field step will create a new record in the related table, but only if one does not already exist. (If a related record exists, the two patient ID fields already have identical values and thus set field makes no actual change to your data.)
Damn, you're good!
Worked like a charm.
Ok, I promise to stop posting for a while and give you a reprieve from stupid questions :)
Thanks for teaching!