What version of FileMaker do you have?
Do you know how to use the script step Go To Related Record?
In any version of FileMaker, Go To Related Record can take you to the related record in the other file. Depending on how recent a version of FileMaker you are using, it may also be possible to specify the layout you want. In some older versions, after using Go To Related Record, you may need to perform a script in the related table's file to select the layout you want.
I am using filemaker 10. I tried to use the script go to related record and I can choose the JOB-ACCOUNTING from the list but I cant choose the layout. I wrote the script Go to Related Record and it is like this:
Go to Related Record [ Show only related records; From Table: "Job Accounting"; Using layout: <Current Layout>]
The JOB-ACCOUNTING database that I am trying to open through button is related with JOB-LIST, the table I am trying to open from.
This is the error that I get:
"This operation could not be completed because this layout cannot display the result."
When you set up the Go To Related Record step, click the "use external table's layouts" check box, then you can select a layout from the external table.