Go to related record in table view

[Nicholas Lue]

I'm sure this is stupid, but why can't I set a field button in a table view to go to the related record in another layout? This is very easy to do in any other layout, but for some reason the table view doesn't like buttons.

[Kent Searight]

Place your buttons in a header or a footer. They won't work in the body in Table view.

[Nicholas Lue]

I was afraid of that. Why won't filemaker allow such an obvious addition to the table view?

[Kent Searight]

Why won't filemaker allow such an obvious addition to the table view?

Actually, that's the logical way for a database table to display, i.e. just show data.

Although the graphic of a button in a container is data, and it will display in Table view, the action attached to that button is not data, therefore it's nonfunctional as a button when it's in the body part of the layout in Table view.

Hope this helps!

[Nicholas Lue]

My need is not really for a button but a way to click on the selected record in a list format and go to that record in the individual object view. I know you can do this using other list layouts, but the table layout is working a lot better for my purposes. I like the way users have control over the width of the column and the ability to sort decending or ascending.

Also, why can't FMP select multiple records in either the list or table view? Holding down a shift key or option key doesn't work.

[Kent Searight]

Have you considered the option of using a portal? It will address everything you want except the ability to adjust column widths in Browse mode.

Also, why can't FMP select multiple records in either the list or table view? Holding down a shift key or option key doesn't work.

Create Found Sets to work with groups of records.

[T-Square]

Or create a List layout that looks like a table, and put the button in the body (or make a data element a button).

If you are wedded to the Table layout (which can be superior when using IWP), and want to navigate to the full view of a record being displayed in table view, you can simply add a button in the header of the table view that uses the Go To Layout command to change to a full view based on the current table occurrence. As long as the record you want is selected, then the Go To Layout command will retain that record.

HTH,

David