You can place an OnObjectEnter script trigger on a field shown in your table view. The script attached to this trigger can switch layouts for you. You can even make a calculation that returns the text: "Click here to see details" and attach the script trigger to it.
The other option is to replace your table view with a list view of the same fields. This gives you the same spreadsheet like view but without some of the table view's flexibility. With list view, you can place buttons directly in the layout row to use in triggering your script.
Hi Phil - How does one insert an OnObjectEnter script trigger? I looked under the "Insert" menu and didn't see it...
Oops, I missed the part of your first post where you said you are using Filemaker 9. Script triggers were added with filemaker 10. You'll have to use the second approach--creating a list view that matches your current table view so that you can either place a button in the body of the layout or define a field as a button to take the user to the detail layout.