cfor Posted February 21, 2009 Posted February 21, 2009 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.
Fenton Posted February 22, 2009 Posted February 22, 2009 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.
cfor Posted February 22, 2009 Author Posted February 22, 2009 Thank-you so much! I was missing the relationship connection needed to make this work. Adding that fixes it.
Recommended Posts
This topic is 5754 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now