This post doesn't appear to have anything to do with FileMaker Server, the topic of this section of the Forum. Would you like me to move this thread to the FM Pro forum for you?
Instead of the portal, add a table occurrence to the table in the other database file where this data is stored. YOu do this by opening Manage | Database | Relationships and clicking the far bottom left button. Then, in the dialog that opens, select Add FileMaker data source in the data source drop down. From there, you can open the other database file and select a table from it.
Once you have added this new table occurrence, you can link it in a relationship. Since you are using Go To Related Records, I would guess that you have already done this. Once you have the table occurrence and relationship that you need, add a layout to this same file that is based on this table occurrence, designed to show the detail info and you can just use Go To related records to switch layouts instead of also switching files.
Thanks for the quick reply. Feel free to move my post to the FM Pro Forum. Sorry about that; we're using FM Server but yes I see that this is not a Server specific question.
I appreciate your suggestion and am trying to implement; however, when I now click the button to GTRR nothing happens.
The steps I took are as follows:
1. I still have the initial portal to list all previous Repairs. When you said "Instead of the portal" I assume you meant instead of my use of the 2nd portal as a means of seeing the Repair details. I still need the original portal to list all jobs.
2. I created a relationship between our new database and the Table containing the related fields in our Repairs database.
3. I created a new layout within my new database showing records from the Repair database's Table.
4. I edited my button to "Get Related Records" from the Repair database's Table, and "Show Record" using the new layout I created.
Again when I hit the button aside from a tiny flash of the button nothing happens. Any ideas?
Thank you again immensely!
I believe I have it figured out. Just some confusion over the relationship setup. Thank you again. This was a HUGE help!!!