February 21, 200916 yr Hopefully I can explain what I'm trying to do so that it makes sense. I have 2 windows open for the same table. A list view and a form view. I want to be able to select a record in the list view window and have the form view window display the same record. I've created a global field that gets the selected record ID passed to it and I can transfer from the current window to the to the form window. What I haven't been able to figure out is how to get the form window to go to the selected record from the list view. using go to related doesn't work as expected so I know that I'm missing some step. Any idea what step is missing? I'm not able to see it. thanks.
February 22, 200916 yr If you've got the unique "record id" of the record in a global field, then you'd want to use the Go To Related Record step, when you get to the 2nd window. A global is the same for all records and windows of a table (and it's the same table). You'd need a relationship based on the global ID to the regular ID field. Commit Records first, as Go To Related Record using a global can be unreliable otherwise (used to be anyway). I don't know for sure what you mean by "record id", as you could mean either the built-in FileMaker record id, or an auto-enter serial ID field you've created. Either would work (in a field) for this purpose. I do not use the built-in one for relationships, as it can change, if you clone the file and reimport records for example. But in your case it would work fine, because you're just transferring an existing ID to another window. FileMaker uses the built-in record id for web operations.
February 22, 200916 yr Author Thank-you so much! I was missing the relationship connection needed to make this work. Adding that fixes it.
Create an account or sign in to comment